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