How to Extract Email Addresses on an Excel Spreadsheet

Save

Whether you are a large corporation with thousands of contacts or a small business with hundreds of clients, filtering out invalid or incorrectly entered email addresses can be difficult. Microsoft Excel allows users to organize their spreadsheets and gives them the flexibility to filter out entries that do not work or no longer needed. If you need to extract email addresses that are invalid or entered incorrectly, creating a filter tool in your email column can help you make extracting email contacts a breeze.

  • Add a drop-down organization 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 email 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 email 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.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!