Data Validation – Use a Formula to Validate Email Addresses

Data validation is a powerful Excel feature that can be used to restrict what data can or should be entered in a cell. You can setup data validation to prevent users from entering invalid data.

In this post I am sharing with you a tip on how to  setup data validation setup to restrict users from entering invalid email addresses by applying a formula based Data Validation rule.

In the example below,  We can create a Data validation formula in Column D by choosing Custom as the validation criteria in the Data Validation settings.

=ISNUMBER(MATCH(“*@*.???”,C2,0))

Post-1

 

This animation demonstrates how it should be done.

post-1-1

 

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s