I have a bunch of emails in column A. I need to identify all emails in
column A that do not have an @ symbol or do not have ".com" ".net" ".edu" etc.

How do I have column B list the bad email addresses and column C be the
emails from column A minus the bad ones?

Please advise.

Thank you!