sort starting from a specific character (@ sign) for email addres
 

I am trying to sort a very large list of email addresses, and I want to start
the sorts from the "@" symbol in each address. Is this possible?

sort starting from a specific character (@ sign) for email addres
 

Insert a column next to your original data and enter the
following formula and copy down as far as you need to go.

=MID(A1,FIND("@",A1)+1,LEN(A1))

Then sort by this column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"RobJ" wrote in message
...
I am trying to sort a very large list of email addresses, and I
want to start
the sorts from the "@" symbol in each address. Is this
possible?