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, [email protected]
is the existing data and I want to create a new column with just the msn.com
string.

Hi,

Assume [email protected] 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, [email protected]
> 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 [email protected] 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, [email protected]
> > 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 [email protected] 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, [email protected]
> > > 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 [email protected] 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, [email protected]
> > > > 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.

Data>Text to Columns>Delimited 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
[email protected]> 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, [email protected]
>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.
>
> Data>Text to Columns>Delimited 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
> [email protected]> 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, [email protected]
> >is the existing data and I want to create a new column with just the msn.com
> >string.
>
>