View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] durbat2@googlemail.com is offline
external usenet poster
 
Posts: 21
Default Extracting text from a string

I have a spreadsheet which imports data in the form R/IVE/0458 I need
to extract data to read IVE 0458 an added complication being that some
times there are 5 digits ie R/IVE/40755 which needs to read IVE 40755

Hope this makes sense, thanks in anticipation

Martin