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)
Printable View
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)
Create a helper column to the right which would be:
=RIGHT(A1,LEN(A1)-FIND("@",A1))
Drag down
Sort by that column.
Thanks Dan
No worries, had to help a fellow Aussie ;)