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" <RobJ@discussions.microsoft.com> wrote in message
news:FE75644C-8CB3-4E11-820F-231DF1C70080@microsoft.com...
>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?