ISEMAIL

The ISEMAIL function in Google Sheets checks whether a given value is a validly formatted email address, returning TRUE or FALSE. It's a quick and reliable way to validate contact data without writing a complex regular expression. Dive into our comprehensive guide to master its use.

Parameters

• value: The value or cell reference to test for a valid email format.

Step-by-Step Tutorial

1. Checking a valid email address:

   • Example: =ISEMAIL("user@example.com")
   • Result: TRUE

2. Checking an invalid value:

   • Example: =ISEMAIL("not-an-email")
   • Result: FALSE

Use Cases and Scenarios

1. Form Data Validation: Verify that user-submitted email addresses are properly formatted before processing.
2. Data Cleaning: Flag invalid or malformed email entries in imported contact lists.
3. Conditional Formatting: Highlight cells with invalid email addresses using ISEMAIL combined with conditional formatting rules.

Related Functions

• ISURL: Checks whether a value is a valid URL.
• ISTEXT: Checks whether a value is text.
• REGEXMATCH: Checks whether a piece of text matches a regular expression.

Related Articles

• Clean Names and Emails with REGEXEXTRACT and SPLIT in Google Sheets