Is this possible?

C

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
 
G

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.
 
R

Ron P

colind said:
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
Click to expand...

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.
--
 
Top