Whether you are a large corporation with thousands of contacts or a small business with hundreds of clients, filtering out invalid or incorrectly entered e-mail addresses can be difficult. Microsoft Excel allows users to organise their spreadsheets and gives them the flexibility to filter out entries that do not work or no longer needed. If you need to extract e-mail addresses that are invalid or entered incorrectly, creating a filter tool in your e-mail column can help you make extracting e-mail contacts a breeze.
- Skill level:
- Moderately Easy
Add a drop-down organisation menu to the top of each column by clicking on the "Data" tab. Choose "AutoFilter" in the slide-out menu to create the drop-down menus.
Click on the drop-down menu and select "Custom."
Set two filters that will extract invalid e-mail addresses. Select the "Does not contain" option in the drop-down menu and type in "@." Set the other filter as a "Does not contain" option and type in a "period."
Press "OK" to begin the filtering.
Look for the email addresses listed in blue. Since e-mail addresses must contain an "@" symbol and at least one "period," the filter will highlight in blue all that don't meet the criteria.
Remove the email addresses by clicking on the cell and pressing the "delete" key on your computer.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for