How to Extract Email Addresses on an Excel Spreadsheet

Written by paul lin
  • Share
  • Tweet
  • Share
  • Email

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


  1. 1

    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.

  2. 2

    Click on the drop-down menu and select "Custom."

  3. 3

    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."

  4. 4

    Press "OK" to begin the filtering.

  5. 5

    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.

  6. 6

    Remove the email addresses by clicking on the cell and pressing the "delete" key on your computer.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.