Extract domain names from email IDs

[sl24]

I have 26000 email Ids i need to split the part that comes after
@([email protected]) i.e google.com.

Also nice to have would be splitting excel/google/com in separate
columns.

Thanks in advance.

SL

 

[Harlan Grove]

I have 26000 email Ids i need to split the part that comes after
@([email protected]) 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.

 

[Gord Dibben]

Data>Text to Columns>Delimited by>Other.

Enter the @ and Finish

To break out google and com use a period as a delimiter.


Gord Dibben MS Excel MVP