Sort column of e-mail addresses

M

Matty

I am trying to sort by the address ending......@?????.com Any ideas? I am
completely lost.

Matt
 
B

Bob Umlas, Excel MVP

Create another column which has =mid(A1,find("@",A1)+1,255) (Where A1 is the
first address), then fill down as far as you need, calculate, if necessary,
then sort both columns on this formula column, then clear this formula column.
Bob Umlas
Excel MVP
 
Top