View Single Post
  #1   Report Post  
Amie G
 
Posts: n/a
Default Need help cleaning up an email list in Excel

I have a very large contacts list in Excel. One column is for email
addresses. Before I send off an email to these folks, I want to make sure
they will all work. There are two things I need help with:

1. How do I find all cells WITHOUT an "@" sign?
2. How do I find all cells with more than 1 "@" sign?

Basically, I want to know that there is only email address in each cell and
that it is legitimate.

Any help you can provide would be most appreciated!

Thanks!