Hi Lowell,

A1: )
B1: =IF(A1="","",LEFT(A1,FIND("(",A1)-1))
C1: =IF(A1="","",MID(A1,FIND("(",A1)+1, LEN(A1)-LEN(B1)-2))

See my page on strints for some OTHER help with strings:
http://www.mvps.org/dmcritchie/excel/stings.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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