auto delete characters in cell left of @ sign

R

Rusty

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.
 
A

Anne Troy

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
 
D

Dave Peterson

Left, right. What's the difference???

So this becomes:
Select the range
edit|replace
what: *@
with: (leave blank)
replace all

And if the hyperlinks (if they existed) should be deleted:
hit alt-f11
hit ctrl-g
type this and hit enter:
selection.hyperlinks.delete

(or just use data|text to columns, <vbg>. and choose to skip the field that
should be deleted)
 
A

Anne Troy

Dave: I wouldn't have bothered replying to you, really; I'm sure you knew
the diff. My message was really to keep Rusty out of trouble. :) xxxooo
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
 
D

Dave Peterson

Well, I appreciate the correction. I often read the question wrong--or just do
something stupid.

But I've learned to save before anything that may cause trouble later. If I
screw it up, I can edit|undo or close without updating.

(Which is a good thing to learn, too.)

Anne said:
Dave: I wouldn't have bothered replying to you, really; I'm sure you knew
the diff. My message was really to keep Rusty out of trouble. :) xxxooo
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Synchronization problems while moving folders to new email 1
Digitally signed email - VB code to remove sig? 0
Custom Auto Replies - exchange server, multiple inboxes 0
Clean text before the @ sign in an Email Address 2
Outlook 2007 has messed up the email addresses for a lot of my contacts 0
Taking Just Domain from Email Address 2

Top