How do I remove all text to the left of the @ in an email address
 

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.

Hi,

Assume appears in A1. In B1 I would insert the
following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1))

Cheers,
Jon

"David M" wrote:

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.

Thanks Jon - I look forwars to working through your formula to understand it.

What I tried in the meantime (and it worked - however it may be just luck)
was to use Ctrl-H (Replace) and inserted a wild card * in the search for
string and then replaced it with nothing (resulst into a new column);

Replace *@ with [nothing] and it worked.

However - I like yours better as it will probably be more reliable.

Thanks for the help.

btw - go the Wallabies!

;-)


"Springbok" wrote:

Hi,

Assume appears in A1. In B1 I would insert the
following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1))

Cheers,
Jon

"David M" wrote:

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.

Thinking of it there are still a number of other methods. Using text to
columns and @ as the delimiter could also work. :-)

"David M" wrote:

Thanks Jon - I look forwars to working through your formula to understand it.

What I tried in the meantime (and it worked - however it may be just luck)
was to use Ctrl-H (Replace) and inserted a wild card * in the search for
string and then replaced it with nothing (resulst into a new column);

Replace *@ with [nothing] and it worked.

However - I like yours better as it will probably be more reliable.

Thanks for the help.

btw - go the Wallabies!

;-)


"Springbok" wrote:

Hi,

Assume appears in A1. In B1 I would insert the
following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1))

Cheers,
Jon

"David M" wrote:

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.

the simpler the better - I like it.



"Springbok" wrote:

Thinking of it there are still a number of other methods. Using text to
columns and @ as the delimiter could also work. :-)

"David M" wrote:

Thanks Jon - I look forwars to working through your formula to understand it.

What I tried in the meantime (and it worked - however it may be just luck)
was to use Ctrl-H (Replace) and inserted a wild card * in the search for
string and then replaced it with nothing (resulst into a new column);

Replace *@ with [nothing] and it worked.

However - I like yours better as it will probably be more reliable.

Thanks for the help.

btw - go the Wallabies!

;-)


"Springbok" wrote:

Hi,

Assume appears in A1. In B1 I would insert the
following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1))

Cheers,
Jon

"David M" wrote:

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.

David

Copy the column then on the copied column.

DataText to ColumnsDelimited by "other". Enter the @ sign.

Import whichever column you want and Finsish.


Gord Dibben Excel MVP

On Tue, 1 Mar 2005 01:01:03 -0800, "David M" <David
wrote:

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.

Thanks Gord!

"Gord Dibben" wrote:

David

Copy the column then on the copied column.

DataText to ColumnsDelimited by "other". Enter the @ sign.

Import whichever column you want and Finsish.


Gord Dibben Excel MVP

On Tue, 1 Mar 2005 01:01:03 -0800, "David M" <David
wrote:

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.