Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disappearing scales on bar charts with multiple series | Charts and Charting in Excel | |||
Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
Click Boxes for each series in a graph | Charts and Charting in Excel | |||
Formula for Returning values in another spreadsheet | Excel Worksheet Functions | |||
Can I add an average series to a chart with 2 or more series? | Charts and Charting in Excel |