Solved: Sorting Email Addresses column

[Aussiebear]

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]

Create a helper column to the right which would be:

=RIGHT(A1,LEN(A1)-FIND("@",A1))

Drag down

Sort by that column.

[Aussiebear]

Thanks Dan

[Blade Hunter]

No worries, had to help a fellow Aussie ;)