There are 2 functions
Returns the hyperlink from a cell. The hyperlink can be one of the following types:
existing file or web page
place in your document
If you afterwards change the hyperlink in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.
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.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext