Posted to microsoft.public.excel.worksheet.functions

[email protected] durbat2@googlemail.com is offline

external usenet poster

Posts: 21

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting text from string	Confused	Excel Worksheet Functions	4	February 15th 08 03:34 PM
Extracting the last set of words from a text string	IPerlovsky	Excel Worksheet Functions	14	March 2nd 07 02:47 AM
extracting numbers within text string!	via135	Excel Worksheet Functions	6	May 5th 06 06:08 AM
Extracting integers from a text string.	Bhupinder Rayat	Excel Worksheet Functions	10	September 28th 05 05:15 PM
Extracting from a text string	AmyTaylor	Excel Worksheet Functions	3	June 24th 05 01:34 PM

All times are GMT +1. The time now is 07:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us