Suppose you have your addresses in Col A
enter this in B1 and copy down
=FIND("@",A1)

You will get #Value! error for those rows where @ part is missing. You can
filter on #VALUE! and delete those rows...

Similarly you can search for a period...

"belharris" wrote:

I have an excel sheet with thousands of email addresses listed down one
column. There are numerous bad emails that are missing the @____ in the
address and we know they will get bounced back. How do I search within this
LONG list for addresses that are missing the @___ part of the address and
delete it so that when we use the list we reduce the bounce backs. Basically
searching for something tht is NOT there and deleting that entry.