I am not an Excel guru, but I would parse/split the data first, then sort on the two halves.

The term for that is creating a 'helper column'

If your 1st e-mail address is in A1, type the following in B1: =IF(ISERROR(FIND("@",A1))=TRUE,"",LEFT(A1,FIND("@",A1)-1))

This should give you the part in front of the "@"

then type this in C1

=IF(ISERROR(FIND("@",A1))=TRUE,"",MID(A1,FIND("@",A1)+1,FIND(".",A1)-FIND("@",A1)-1))

This should give you the part between the "@" and the first "."

Hope this helps.

## I use MS Excel 2010. I have a list that conains email and non-email address

Thanks

Edward