Is this possible?

[colind]

Hi i'm new here, so don't know if this questioin has been answered.

I have a list of about 500 email addresses, which i need to find out if
any of the providers are the same. after the @ symbol.

So imagine 500 of these addresses, most with different provider, but
some will be the same is there any way on excel that i can arrange them
by that. A kind of ascending thing, but not using the first part of the
name in the cell, but the middle, for instance
joe.blogs@*::wherever::*.com

Anyone know if this is possible

Cheers

Colin

 

[Guest]

Hi

You could use a helper column with this in:
=MID(A2,FIND("@",A2)+1,255)
to strip out the domain bit, and analyse that.

Andy.

 

[Ron P]

Hi i'm new here, so don't know if this questioin has been answered.

I have a list of about 500 email addresses, which i need to find out if
any of the providers are the same. after the @ symbol.

So imagine 500 of these addresses, most with different provider, but
some will be the same is there any way on excel that i can arrange them
by that. A kind of ascending thing, but not using the first part of the
name in the cell, but the middle, for instance
joe.blogs@*::wherever::*.com

Anyone know if this is possible

If all of the email addresses are in one column, insert a blank column to
the right of this column (if there isn't a blank column already). Highlight
the column of email addresses and then choose DATA/TEXT TO COLUMNS. Select
DELIMITED and choose the @ sign as the delimiter. This should move
everything to the right of the @ sign into the blank column.
--