 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2005delete 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: kendraa@ecollege.com becomes ecollege.com only. How can I do that? Try this formula in a blank cell where "A1" is the cell containing the email address. =RIGHT(A1,LEN(A1)-FIND("@",A1,1))  SignatureClaude S > 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: kendraa@ecollege.com becomes ecollege.com > only. How can I do that? Just copy that into one cell, cell A1? All I get is a "0" ?? > Try this formula in a blank cell where "A1" is the cell containing the email > address. =RIGHT(A1,LEN(A1)-FIND("@",A1,1)) [quoted text clipped - 3 lines] > > across the whole spreadsheet. EG: kendraa@ecollege.com becomes ecollege.com > > only. How can I do that? 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 >Just copy that into one cell, cell A1? >All I get is a "0" [quoted text clipped - 7 lines] >> > across the whole spreadsheet. EG: kendraa@ecollege.com becomes ecollege.com >> > only. How can I do that? AWESOME Thank you!!!!!!!!!!!!!!!!! > Kendraa > [quoted text clipped - 28 lines] > >> > across the whole spreadsheet. EG: kendraa@ecollege.com becomes ecollege.com > >> > only. How can I do that? You're welcome. Which method did you use? Formula or Text to Columns? Gord Dibben Excel MVP >AWESOME >Thank you!!!!!!!!!!!!!!!!! [quoted text clipped - 31 lines] >> >> > across the whole spreadsheet. EG: kendraa@ecollege.com becomes ecollege.com >> >> > only. How can I do that? Data>Text to Columns>Delimited by>@ Choose to skip importing the first column. Gord Dibben Excel MVP >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: kendraa@ecollege.com becomes ecollege.com >only. How can I do that? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.