auto delete characters in cell left of @ sign
 

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.

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.

auto delete characters in cell left of @ sign
 

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

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

auto delete characters in cell left of @ sign
 

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.

auto delete characters in cell left of @ sign
 

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)


Anne Troy wrote:

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

--

Dave Peterson

auto delete characters in cell left of @ sign
 

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

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

auto delete characters in cell left of @ sign
 

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

"Dave Peterson" wrote in message
...
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)


Anne Troy wrote:

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

--

Dave Peterson

auto delete characters in cell left of @ sign
 

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 Troy wrote:

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

"Dave Peterson" wrote in message
...
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)


Anne Troy wrote:

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

--

Dave Peterson

--

Dave Peterson

auto delete characters in cell left of @ sign
 

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

"Dave Peterson" wrote in message
...
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 Troy wrote:

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

"Dave Peterson" wrote in message
...
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)


Anne Troy wrote:

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

--

Dave Peterson

--

Dave Peterson