Is the email address always enclosed by parenthesis ending with one?

if so it's pretty easy

=SUBSTITUTE(MID(A1,FIND("(",A1)+1,1024),")","")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Lowell" wrote in message
...
I was wondering if someone could hel me with the following problem. I have
several names and email addresses that are in Excel and that I needto
seperate the email addresses from the string of characters. The list is
in
column A.

)

What I want to end up with is

Thanks for any help

--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida