Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Address List in Excel | Excel Discussion (Misc queries) | |||
Email hyperlink changes not showing in excel | Excel Worksheet Functions | |||
How do I automatically send daily email of updated Excel workbook. | Excel Discussion (Misc queries) | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
Create a cascading list box using Excel | Excel Discussion (Misc queries) |