Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract domain names from email IDs
I have 26000 email Ids i need to split the part that comes after
) i.e google.com. Also nice to have would be splitting excel/google/com in separate columns. Thanks in advance. SL |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract domain names from email IDs
"sl24" wrote...
I have 26000 email Ids i need to split the part that comes after ) i.e google.com. Also nice to have would be splitting excel/google/com in separate columns. Yet another misuse of Excel as a system administration tool. Oh well. Select the range of e-mail IDs, run the menu command Data Text to Columns, choose Delimited in the first part of the wizard, then enter @ as the Other character. That'll split the account name from the domain name. Then select the range of domain names and run Data Text to Columns, Delimited again, but change the Other character to a period. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract domain names from email IDs
DataText to ColumnsDelimited byOther.
Enter the @ and Finish To break out google and com use a period as a delimiter. Gord Dibben MS Excel MVP On Mon, 20 Aug 2007 23:06:26 -0700, sl24 wrote: I have 26000 email Ids i need to split the part that comes after ) i.e google.com. Also nice to have would be splitting excel/google/com in separate columns. Thanks in advance. SL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract email address in hyperlink | Excel Worksheet Functions | |||
Extract email addresses | Excel Worksheet Functions | |||
Email worksheet from a list of names and email | Excel Discussion (Misc queries) | |||
How can I get the domain name out a email adress? | Excel Worksheet Functions | |||
How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) |