delete series of letter in spreadsheet

[Guest]

I have a large document that contains thousands of email addresses. I want
to delete the part that becomes before the "@" sign, inlcuding the "@" sign
across the whole spreadsheet. EG: (e-mail address removed) becomes ecollege.com
only. How can I do that?

 

[Guest]

Try this formula in a blank cell where "A1" is the cell containing the email
address. =RIGHT(A1,LEN(A1)-FIND("@",A1,1))

 

[Gord Dibben]

Data>Text to Columns>Delimited by>@

Choose to skip importing the first column.


Gord Dibben Excel MVP

 

[Guest]

Just copy that into one cell, cell A1?
All I get is a "0"
??

 

[Gord Dibben]

Kendraa

Assuming your email addresses are in Column A, copy the formula into B1 then

hover the mouse pointer over the bottom right corner of B1. You will see a
black lump and a black cross.

Double-click on that lump to replicate/increment the formula down Column B
until no data in column A.

In B2 it will change to =RIGHT(A2,LEN(A2)-FIND("@",A2,1)) and so on down
Column B.

I would go with Data>Text to Columns>Delimited by>enter the @ sign in "Other"
box.

Make sure you check the "skip" for the first column or have an empty column to
the right of the address column.


Gord Dibben Excel MVP

 

[Guest]

AWESOME
Thank you!!!!!!!!!!!!!!!!!

Kendraa

Assuming your email addresses are in Column A, copy the formula into B1 then

hover the mouse pointer over the bottom right corner of B1. You will see a
black lump and a black cross.

Double-click on that lump to replicate/increment the formula down Column B
until no data in column A.

In B2 it will change to =RIGHT(A2,LEN(A2)-FIND("@",A2,1)) and so on down
Column B.

I would go with Data>Text to Columns>Delimited by>enter the @ sign in "Other"
box.

Make sure you check the "skip" for the first column or have an empty column to
the right of the address column.


Gord Dibben Excel MVP

 

[Gord Dibben]

You're welcome.

Which method did you use?

Formula or Text to Columns?


Gord Dibben Excel MVP