Thread
:
Extracting text from a string
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Extracting text from a string
Try:
=MID(A1,FIND("/",A1)+1,255)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
" wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann