ISEMAILADDRESS
Syntax
ISEMAILADDRESS (expression)
Description
Determines if the specified expression is a valid email address.
Arguments
| expression | Expression to be evaluated. |
Returns
If expression is recognizable as a valid email address, it returns True.
If expression is not recognizable as a valid email address, it returns False.
Remarks
The pattern of the address must be x@y.z
- X can contain any combination of letters, numbers, period, hyphen (-), underscore (_), single quote (') or plus (+).
- Y can contain any combination of letters, numbers, or hyphen (-).
- Z can contain any combination of letters, numbers, or period (.).
If the email addresses do not meet this criteria, the ISREGEXEXACTMATCH function can be used instead.
Examples
ISEMAILADDRESS ( “customer@gmail.com" )
Returns: True
ISEMAILADDRESS ( “40 Elm Street" )
Returns: False