View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Anne Troy
 
Posts: n/a
Default auto delete characters in cell left of @ sign

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