HYPERLINK function
HYPERLINK returns a link that points to a network resource or to a range referenced by the link. If you use the optional cell_text argument, the formula locates the URL, and then the cell_text value is displayed.
Syntax
HYPERLINK(link,cell_text)
- link specifies the link target.
- cell_text (optional) is the text or a number that is displayed in the cell and is returned as the result. If the cell_text argument is not specified, the URL is displayed in the cell text and is returned as the result.
Example
=HYPERLINK("http://www.example.org") shows the text http://www.example.org in the cell and executes the hyperlink http://www.example.org when clicked.
=HYPERLINK("http://www.example.org","Click here") shows the text Click here in the cell and executes the hyperlink http://www.example.org when clicked.
=HYPERLINK("http://www.example.org",12345) shows the number 12345 and opens the hyperlink http://www.example.org when clicked.
=HYPERLINK($B4) where
cell B4 contains http://www.example.org. The function adds http://www.example.org
to
the URL of the hyperlink cell and returns the same text that is used
as the formula result.