brothertruffle880
asked on
Excel 2013 - How to Sort on the SECOND CHARACTER of an email address (eg. the "f" in afrankel@aaa.com)
How to sort email addresses on the SECOND character of the name field. EXAMPLE:
danderson@xyz.com
bberringer@xyz.com
qhubbard@xyz.com
cjones@aaa.com
WHEN THE ABOVE IS SORTED, it should look like this:
danderson@xyz.com
bberringer@xyz.com
qhubbard@xyz.com
cjones@aaa.com
danderson@xyz.com
bberringer@xyz.com
qhubbard@xyz.com
cjones@aaa.com
WHEN THE ABOVE IS SORTED, it should look like this:
danderson@xyz.com
bberringer@xyz.com
qhubbard@xyz.com
cjones@aaa.com
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER