ISEMAIL (Address) ISEMAIL (Address)
Address
Text Text
The potential email address.
Returns
Logical Logical
Whether the given text string is probably an email address.
Returns whether the given text string is probably an email address. ISEMAIL ("support@example.com") ISEMAIL ("support@example.com") returns TRUE, but ISEMAIL ("support at example.com") ISEMAIL ("support at example.com") returns FALSE.
This function uses the same technique that web browsers use when determining if an input email field is valid . It does not strictly conform to the standard dictating what email addresses may and may not contain, for practical reasons.
This function is not commonly supported by spreadsheets.
Examples
ISEMAIL ("support@example.com")
ISEMAIL ("support@example.com")
Returns TRUE.
ISEMAIL ("support at example.com")
ISEMAIL ("support at example.com")
Returns FALSE.