auto delete characters in cell left of @ sign

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rusty - 20 Jan 2006 19:24 GMT

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.

Reply to this Message

Anne Troy - 20 Jan 2006 19:42 GMT

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

>I have a spreadsheet with about 1000 email addresses. All I want from
>those
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Rusty - 20 Jan 2006 20:51 GMT

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

> Try Data-->Text to columns and use the @ sign as the delimiter. Simple,
> right? :)
[quoted text clipped - 12 lines]
> >
> > Thanks.

Reply to this Message

Anne Troy - 20 Jan 2006 21:04 GMT

You're welcome, Rusty! :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

> Anne, you are my hero. It worked perfectly in a matter of seconds!
> Thanks a
[quoted text clipped - 18 lines]
>> >
>> > Thanks.

Reply to this Message

Dave Peterson - 20 Jan 2006 19:49 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Thanks.

Signature

Dave Peterson

Reply to this Message

Anne Troy - 20 Jan 2006 20:00 GMT

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

> Select the range
> edit|replace
[quoted text clipped - 11 lines]
>>
>> Thanks.

Reply to this Message

Dave Peterson - 20 Jan 2006 20:55 GMT

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)

> Dave: That will:
> a) delete the domain name, which is what Rusty wants to keep
[quoted text clipped - 25 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Anne Troy - 20 Jan 2006 21:06 GMT

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

> Left, right. What's the difference???
>
[quoted text clipped - 46 lines]
>> >
>> > Dave Peterson

Reply to this Message

Dave Peterson - 20 Jan 2006 22:34 GMT

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

> 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
[quoted text clipped - 57 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Anne Troy - 23 Jan 2006 18:14 GMT

Indeed! :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

> Well, I appreciate the correction. I often read the question wrong--or
> just do
[quoted text clipped - 70 lines]
>> >
>> > Dave Peterson

Reply to this Message