View Full Version : Solved: Sorting Email Addresses column
Aussiebear
05-10-2010, 05:56 PM
I am currently in need of sorting a worksheet based on a column containing email addresses. However its not a standard sort. The reference needs to be based on the second part of the email address ( ie. everything after the "@" symbol)
Blade Hunter
05-10-2010, 06:12 PM
Create a helper column to the right which would be:
=RIGHT(A1,LEN(A1)-FIND("@",A1))
Drag down
Sort by that column.
Aussiebear
05-10-2010, 06:35 PM
Thanks Dan
Blade Hunter
05-10-2010, 06:37 PM
No worries, had to help a fellow Aussie ;)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.