Anne, you are my hero. It worked perfectly in a matter of seconds! Thanks a
ton.

"Anne Troy" wrote:

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.