Posted to microsoft.public.excel.programming

Michael[_44_] Michael[_44_] is offline

external usenet poster

Posts: 31

Parsing Strings in Excel

I have a list in Excel from A1:A100 with names like the ones mentioned
below:

Michelle Fooo )
Myhaass Smith )

I want to parse them using string functions to the following format

Any ideas how to do this using a formula?

Thanks in advance
Michael

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
find and replace numeric strings in larger text strings	Mr Molio	Excel Worksheet Functions	8	November 9th 11 05:17 PM
Parsing Name Strings In Excel	Cliff-D	Excel Discussion (Misc queries)	0	June 10th 10 02:02 AM
Macro to apply parsing rules for strings and list the substrings	Luciano Paulino da Silva	Excel Worksheet Functions	25	May 3rd 09 11:53 AM
String parsing with variable lenght strings	frosterrj	Excel Worksheet Functions	10	March 31st 06 11:46 PM
Parsing Text Strings	Nigel[_6_]	Excel Programming	0	February 20th 04 07:27 PM

All times are GMT +1. The time now is 06:58 AM.

About Us

"It's about Microsoft Excel"