HYPERLINKGET
HYPERLINKGET(value)
Returns the hyperlink associated with a particular cell.
| 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. |
REMARKS
There are 2 functions
|
1 - What is the
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.
HYPERLINKGET_DOMAIN
DOMAINGET = ASAPGETDOMAIN(text, optional show_protocol = False)
Returns the (sub)domain from a given hyperlink (website address/url).
For example if cell A1 contains the value "https://www.bettersolutions.com/index.htm" then these are the formula results:
text = The value or cell address from which you want to extract the domain.
show_protocol = Optional, logical value, if omitted the default is FALSE. If TRUE this function will also return the protocol of the link, which is the part before the domain such as http://, ftp:// etc..
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext