About the ISEMAIL Function
Overview of ISEMAIL
| Check if a Value is a Valid Email AddressGoogle Sheets Function | ||
|
=ISEMAIL( value ) Summary The ISEMAIL function checks if a given value is in a valid email address format and returns TRUE or FALSE. |
||
|
When to Use ISEMAIL
- To confirm whether a cell value is a valid email address.
- To verify that entered data is in the correct format.
- To identify valid email addresses from a list or dataset.
How to Use ISEMAIL
The following table explains the basic usage of the ISEMAIL function.
| A | B | |
|---|---|---|
| 1 | Value | Validation |
| 2 | user@example.com | =ISEMAIL(A2) |
| 3 | invalid-email | =ISEMAIL(A3) |
| 4 | user.name@domain.co | =ISEMAIL(A4) |
| 5 | example@.com | =ISEMAIL(A5) |
Results
| A | B | |
|---|---|---|
| 1 | Value | Validation |
| 2 | user@example.com | TRUE |
| 3 | invalid-email | FALSE |
| 4 | user.name@domain.co | TRUE |
| 5 | example@.com | FALSE |
Advanced Examples
Example 1: Extract Valid Email Addresses
Here’s how to extract only valid email addresses from a list.
| A | B | |
|---|---|---|
| 1 | Value | Valid Email? |
| 2 | user@example.com | TRUE |
| 3 | invalid-email | FALSE |
| 4 | user.name@domain.co | TRUE |
| 5 | example@.com | FALSE |
=FILTER(A2:A5, ISEMAIL(A2:A5))
Result
- Only valid email addresses (user@example.com, user.name@domain.co) are extracted.
Points to Note
- ISEMAIL checks whether a value is in the correct email address format but does not verify if the email address exists.
- An “@” symbol followed by a domain is required; incomplete formats return FALSE.
- While useful for error checking, additional methods may be needed for in-depth email validation.
Conclusion
- The ISEMAIL function is a convenient tool for determining if a cell value is in a valid email format.
- While it cannot confirm the existence of the email address, it is ideal for data validation and list management.
- Combining it with other functions allows for efficient data processing.