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

Try Data--Text to columns and use the @ sign as the delimiter. Simple,
right? :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Rusty" wrote in message
...
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.