Parsing Names in Excel

[Michael]

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

Michelle Fooo ([email protected])
Myhaass Smith ([email protected])


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

(e-mail address removed)
(e-mail address removed)

Any ideas how to do this using a formula?

Thanks in advance
Michael

 

[Nick Hodge]

Michael

Are you wanting to strip all the name out too or just remove the exchange.?

If the latter just use edit>replace What:=exchange. and leave the with blank

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Michael]

The solution was

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Jason Lepack provided the answer.

Thanks
Michael

 

[KC Rippstein]

This does not look like it removed the word "exchange." from the email
addresses as requested. This would be better suited if "exchange." always
shows up the way it does in your example.

=MID(A1,FIND("(",A1)+1,FIND("@",A1)+1-FIND("(",A1)-1)&MID(A1,FIND("@",A1)+10,FIND(")",A1)-FIND("@",A1)-10)

-KC