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


--
colind
------------------------------------------------------------------------
colind's Profile: http://www.excelforum.com/member.php...o&userid=32451
View this thread: http://www.excelforum.com/showthread...hreadid=522249

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.

"colind" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>
>
> --
> colind
> ------------------------------------------------------------------------
> colind's Profile:
> http://www.excelforum.com/member.php...o&userid=32451
> View this thread: http://www.excelforum.com/showthread...hreadid=522249
>

"colind" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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.
--