View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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.