Posted to microsoft.public.excel.worksheet.functions

confused

external usenet poster

Posts: 193

Extracting text from string

How can I extract the following string: Aaa/AAA/AAA? These need to be
extracted into three separate column. The end result would look like this
Aaa (in column 1), AAA (in column 2), AAA (in column 3).

Can someone please help me?

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 the last set of words from a text string	IPerlovsky	Excel Worksheet Functions	14	March 2nd 07 02:47 AM
Extracting a numbers from a text string	IPerlovsky	Excel Worksheet Functions	24	February 27th 07 04:55 PM
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
Extracting Surname from within a text string	Iainkerr01	Excel Worksheet Functions	6	March 14th 05 10:16 AM

All times are GMT +1. The time now is 04:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us