delete series of letter in spreadsheet
 

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?

delete series of letter in spreadsheet
 

Try this formula in a blank cell where "A1" is the cell containing the email
address. =RIGHT(A1,LEN(A1)-FIND("@",A1,1))
--
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?

delete series of letter in spreadsheet
 

DataText to ColumnsDelimited by@

Choose to skip importing the first column.


Gord Dibben Excel MVP


On Fri, 18 Nov 2005 15:12:01 -0800, "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?

delete series of letter in spreadsheet
 

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. =RIGHT(A1,LEN(A1)-FIND("@",A1,1))
--
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?

delete series of letter in spreadsheet
 

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?

delete series of letter in spreadsheet
 

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

"Gord Dibben" wrote:

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?

delete series of letter in spreadsheet
 

You're welcome.

Which method did you use?

Formula or Text to Columns?


Gord Dibben Excel MVP

On Mon, 21 Nov 2005 15:13:02 -0800, "kendraa"
wrote:

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

"Gord Dibben" wrote:

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?