• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide

December 10, 2022 by Admin Leave a Comment

In Google Spreadsheet you can check whether the value entered is a proper email address by creating a data validation rule. This rule does a simple verification and checks for the @ symbol in the entered value. Let us say you have a column in your spreadsheet that needs to accept only email addresses, then you can do the following to add the validation.

Select the Column values, click the Data menu and select Validation from the menu list.

In the Data Validation window, select Text, Contains for the Criteria drop down and specify the value as @

And if you want to display a message to the user then type the message in Help text some thing like “Enter proper email address example aaaa@xxx.xxx”. Click on the Save button to save the changes.

Now when you enter a value in the email address column without the @ symbol then it would display the message as shown below.

Filed Under: Excel, Technical Tagged With: Contains, Data Validation, email address, Google Spreadsheet, Validate

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023