Dave: That will:
a) delete the domain name, which is what Rusty wants to keep
b) leave the hyperlink still on the cell, which I would think he doesn't
want
Right? :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
"Dave Peterson" wrote in message
...
Select the range
edit|replace
what: @*
with: (leave blank)
replace all
Rusty wrote:
I have a spreadsheet with about 1000 email addresses. All I want from
those
email addresses is the domain name. Can anyone tell me a quick way to
automatically delete all the text to the left of the @ sign in the email
address? I can do it manually, but that's awfully boring not to mention
time
consuming.
Thanks.
--
Dave Peterson