P
Pete
Delete data in a cell before the @ sign in an email address
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=RIGHT(A1,LEN(A1)-FIND("@",A1)+1) including the @
=RIGHT(A1,LEN(A1)-FIND("@",A1)) to not include the @
=RIGHT(A1,LEN(A1)-FIND("@",A1)) to not include the @
J
JE McGimpsey
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
=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
P
Pete
Hi Gary
Do I just copy the formula in field B1 and run it?
Ta Pete
Do I just copy the formula in field B1 and run it?
Ta Pete
G
Gary''s Student
Yes. If A1 contains the email address.