How do I sort...

[RickB]

A bunch of e-mail addresses by their domain names? I have 600 e-mail
addresses that I need to sort by domain name. How can I sort that?

Thanks,
RickB

 

[AltaEgo]

Use this formula and sort on the result:

=RIGHT(A1,LEN(A1)-FIND("@",A1))

NOTE: the above assumes the first email address is in cell A1. You will need
to modify all references to A1 and copy down to the rest.

 

[RickB]

Thanks,

I'm closer now!

RickB

Use this formula and sort on the result:

=RIGHT(A1,LEN(A1)-FIND("@",A1))

NOTE: the above assumes the first email address is in cell A1. You will need
to modify all references to A1 and copy down to the rest.