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)
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)
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Create a helper column to the right which would be:
=RIGHT(A1,LEN(A1)-FIND("@",A1))
Drag down
Sort by that column.
Thanks Dan
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
No worries, had to help a fellow Aussie
Posting Permissions
Reply With Quote