Verify a Valid Email Address (14/20)


If you are typing email addresses in Google Sheets, you have to make sure that the data you entered is correct. The easiest way to do this is by confirming that the email address format is correct. You can do this by Data Verification. First, select the cells where you want to apply data validation. Then, select Data → Data Validation from the navigation menu. Then you will see a small window you have to fill in. Make sure the Cell range is correct and choose 'Text' and 'contains' for 'Criteria.' Next, enter the @ symbol in the box next to 'contains.' Next, for 'On Invalid Data' you can either choose 'Show Warning' or 'Reject Input.'

talkKs editorial
Use the comment section to suggest new list items for inclusion

Comments 0

Your email address will not be published. Required fields are marked *

Solve : Which Number is Larger 3 or 6 ?

You are invited to the talkKs Reader Community

Join Now