Sorting a large list of emails

Hello,

I am trying to check the validity of 13k+ email addresses that were manually entered into a spreadsheet. There are common mistakes made in the list. I am looking to sort it by these mistakes like:

catching all the emails with various domain names that end with --@yaho.com instead of --@yahoo.com

Catching all the emails that don't include an @ sign

I basically need to know how to mark all lines that include certain things or exclude certain things.

Thanks