How do I sort...

  • Thread starter Thread starter RickB
  • Start date Start date
R

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
 
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.
 
Thanks,

I'm closer now!

RickB

AltaEgo said:
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.
Click to expand...
 
Back
Top