If you have a list of email addresses in Excel that you need to validate follow proper format, or would like to prevent other Excel users from entering invalid addresses in a column, use Data Validation. By using a custom formula as the validation criteria, email address validation can be done. To get started, with the cells you need validated selected go to Data > Data Validation.
Continue reading “Excel Email Validation with Data Validation Tools”