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

R

RobJ

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?
 
C

Chip Pearson

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
 
Top