Formula help 1

[jasonsas]

HI,

I'm not even sure if there is a way to do this, but I'll ask. I have cells which show a users name along with their email address. They look like this:

john smith (jsmith@whatever.com)

I need to extract just the email address to another cell. Is this possible, as I don't want to have to go through each cell manually.

Thanks,
Jason

 

[macropod]

Hi Jason,

For data in A1:
=MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1)

Cheers

[MS MVP - Word]

 

[jasonsas]

Yes, that worked!!

Thanks Macropod. Not really sure how the formula's working, but it's working!!!

Thanks for the quick reply.