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?

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" <[email protected]> wrote in message
news:[email protected]...
>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?