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!

There are a LOT of domain name extensions, esp. when you
consider all of the country extentions in the world. You
might be OK with:

=COUNTIF(A1,"*@*.*")0

Fill the formula down the col., then apply an AutoFilter
and filter for TRUE.

Or, if you really want to look for specific domain name
extensions, give this a try:

=SUMPRODUCT(--(ISNUMBER(SEARCH("*@*."&
{"com","org","edu","biz","gov","us","net","info"}, A1))))0

HTH
Jason
Atlanta, GA, USA




-----Original Message-----
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!
.