Delete data
 

Delete data in a cell before the @ sign in an email address

Delete data
 

=RIGHT(A1,LEN(A1)-FIND("@",A1)+1) including the @
=RIGHT(A1,LEN(A1)-FIND("@",A1)) to not include the @

--
Gary's Student
gsnu200704


"Pete" wrote:

Delete data in a cell before the @ sign in an email address

Delete data
 

One way, using a formula:

=MID(A1,FIND("@",A1)+1,256)

To do it in place:

Choose Data/Text to Columns/Delimited, click Next. Check "Other" and
enter "@" in the input box. Click Next. Select the first column and
select the Do Not Import Column (Skip) radio button. Click Finish

In article ,
Pete wrote:

Delete data in a cell before the @ sign in an email address

Delete data
 

Hi Gary
Do I just copy the formula in field B1 and run it?

Ta Pete

"Gary''s Student" wrote:

=RIGHT(A1,LEN(A1)-FIND("@",A1)+1) including the @
=RIGHT(A1,LEN(A1)-FIND("@",A1)) to not include the @

--
Gary's Student
gsnu200704


"Pete" wrote:

Delete data in a cell before the @ sign in an email address

Delete data
 

Yes. If A1 contains the email address.
--
Gary''s Student
gsnu200704


"Pete" wrote:

Hi Gary
Do I just copy the formula in field B1 and run it?

Ta Pete

"Gary''s Student" wrote:

=RIGHT(A1,LEN(A1)-FIND("@",A1)+1) including the @
=RIGHT(A1,LEN(A1)-FIND("@",A1)) to not include the @

--
Gary's Student
gsnu200704


"Pete" wrote:

Delete data in a cell before the @ sign in an email address