View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
la90292
 
Posts: n/a
Default How to Sort Invalid Email Addresses?

My customer base of 5,000+ records (columns a-l) has some invalid email
addresses in column g. The "@" is missing. I would like to have those
particular email addresses sorted at the beginning of the list so that I can
go through them and see if they can be corrected or deleted.

Which formula would work best for this project?

Thanks for your help.

Best regards,
victor