Parsing Strings 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

 

[Jason Lepack]

I put your two tests in Cells A1 and A2.

Paste this into a column and fill down:
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Cheers,
Jason Lepack

 

[Nick Hodge]

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
(e-mail address removed)
www.nickhodge.co.uk

 

[Nick Hodge]

Jason

That won't remove the exchange bit (I suspect they've moved servers ;-))

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

 

[Nick Hodge]

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
(e-mail address removed)
www.nickhodge.co.uk

 

[Michael]

This was exactly what I was looking for.

Thanks
Michael

 

[Nick Hodge]

Michael

How does that remove the 'exchange' part?

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

 

[Michael]

Thanks! This is awesome

- Michael

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
(e-mail address removed)
www.nickhodge.co.uk