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 DataText to ColumnsDelimited byenter 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


On Mon, 21 Nov 2005 13:09:08 -0800, "kendraa"
wrote:

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

"Claude S" wrote:

Try this formula in a blank cell where "A1" is the cell containing the email
address.
--
Claude S


"kendraa" wrote:

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: becomes ecollege.com
only. How can I do that?