can i sort email addresses in vers 2002?

[anon125]

i need to sort them by the bit after the @ sign. (the domain?)
so xyz@email.com
comes after 1234@aaa.com.
is there some way of telling excel... go look for the @ and then copy all that is after it.
if the result is say on the right then i could sort them by domain name then.
thanks all

[popipipo]

=RIGHT(A1,LEN(A1)-FIND("@",A1))
Try this one

[alansidman]

Assume your data is in column A. In a helper column, type =RIGHT(A1,LEN(A1)-FIND("@",A1)) and copy down. Then sort on your new column.

[AlKey]

In B2

=MID(A2,FIND("@",A2)+1,FIND(".",A2)-FIND("@",A2)-1)

Apply filter for row 1 and sort by column B

	A	B
1	Address	Filter
2	xyz@aaa.com.	aaa
3	xyz@email.com	email
4	Alex@gmail.com	gmail
5	Bella@Yahoo.com	Yahoo

[anon125]

thanks a lot guys!