HYPERLINKGET

There are 2 functions

Remarks

* For instructions on how to add a function to a workbook refer to the page under Inserting Functions
* The equivalent JavaScript function is HYPERLINKGET

HYPERLINKGET

Returns the hyperlink from a cell. The hyperlink can be one of the following types:
existing file or web page
place in your document
e-mail address
If you afterwards change the hyperlink in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.

Parameters:
cell = The cell to read the hyperlink from.
text_no_link = Optional, this text will be displayed if the cell doesn't have a hyperlinks. If omitted, the formula will give an empty result for cells without hyperlinks.

HYPERLINKGET_DOMAIN