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
|