Validating Emails in Excel

  • Data Tab
  • Highlight column with email addresses
  • click on Filter
  • Click on drop-down box which appears at top of column
  • go to “Text Filters”
  • Click on “Custom Filter”
  • in the first box, click “Does Not Contain”
  • type in “@” in the right box
  •  in the bottom box select “Does Not Contain”
  • type a “.”
  • select the “OR” radio button
  • click OK

Download the Free Home version of ASAP Utilities here ASAP Utilities from

  • Install ASAP Utilities
  • Click on the new ASAP utilities Tab in Excel
  • click on “Text” tools
  • Click on “Delete Leading, Trailing, and Excessive Spaces”
  • you can click on the “Web” tools and click “Remove all Hyperlinks” as well

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s