ISURLChecks whether a value is a valid URL.
Sample Usage
ISURL(“http://www.google.com”)
ISURL(“www.google.com”)
ISURL(“google.com”)
Syntax
ISURL(value)
value – The value to be verified as a URL.
Notes
Google Sheets automatically links text entered into a cell if a valid URL is detected. ISURL will return TRUE in these cases.
A fully qualified URL is not required. In other words, “http” and “www” are not needed in all cases.
Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim.
See Also
ISEMAIL: Checks whether a value is a valid email address.
ISERROR: Checks whether a value is an error.
ISTEXT: Checks whether a value is text.
ISBLANK: Checks whether the referenced cell is empty.
HYPERLINK: Creates a hyperlink inside a cell.