Top Letter Domain

Sort and Excel Column by a part a word in the field.?

If for instance you have a column with 20 random emails with @yahoo or @hotmail at the end of them... Is there a way to sort the column so all yahoos go to the top and all hotmails go to the bottom? The first letters before the domains are completely random so a normal sort alphabetically doesn't work.

Say all your email addresses are in Column E, in cell F1 you can add the following formula
=IF(ISERROR( FIND("@yahoo",E1 ))=FALSE,1,IF( ISERROR(FIND( "@hotmail",E1 ))=FALSE,2,0))
copy it down the column to match all email addresses, if it is yahoo email address, it returns 1, hotmail's, it returns 2, others', it return 0. Then sort the emails column with the number column.

Max B - Letter to the Game

RKOY.com - 4 Letter Domain! Top Level. Make Offer! $18,000.00