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.

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell