View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
belharris belharris is offline
external usenet poster
 
Posts: 3
Default How do I eliminate bad email addresses from column list?

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.