ISEMAIL
True when text looks like an email address.
- Excel: No equivalent
- Google Sheets: Not checked yet
- Returns: Boolean
Examples
=ISEMAIL("a@b.com") Result true
Syntax
ISEMAIL(value) value- text required
Related
CELLInformation about a cell's formatting, location or contents. ERROR.TYPEReturns number corresponding to an error type. FORMULATEXTReturns formula as a text string. INFOInformation about the operating environment. ISBLANKReturns TRUE if value is blank. ISDATETrue when a value can be read as a date.