One more technique.

Say your list is in column A.
Copy it to column B
(Now you have two identical columns)

Select column A
edit|replace
what: (* (open parenthesis followed by asterisk)
with: (leave blank)
replace all

Select column B
edit|replace
what: *( (asterisk followed by open parenthesis)
with: (leave blank)
replace all
and one more time for the closing ).

Edit|replace
what: )
with: (leave blank)
replace all



Lowell wrote:

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

--

Dave Peterson