Posted to microsoft.public.excel.programming
|
|
Parsing Strings in Excel
Thanks! This is awesome :)
- Michael
"Nick Hodge" wrote in message
...
Or maybe you want them all lower case too
=LOWER(REPLACE(MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1),FIND("@",MID(A1,FIND("(",A1),LEN(A1)-FIND("(",A1)-1)),9,""))
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Nick Hodge" wrote in message
...
One possible answer in the other group, but if you want the names out as
well then
=REPLACE(MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1),FIND("@",MID(A1,FIND("(",A1),LEN(A1)-FIND("(",A1)-1)),9,"")
(Assuming first email is in A1)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Michael" wrote in message
...
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
|