Building hyperlinks

Desktop editors
1

using desktop spreadsheet editor on windows 10, xlsx format…
does OO allow me to ‘build’ a url for the hyperlink() function?

ex. (simplified)
=HYPERLINK(A1 & A2, “somename”)

2

Hello @a_c

I am taking closer look at HYPERLINK function in such cases, I’ll keep you posted.

By the way, you can build clickable link to specific range which is selected after pressing the hyperlink via context menu:

  1. Select a cell you’d like to insert hyperlink;
  2. Right-click it and choose Hyperlink;
  3. In the hyperlink settings switch to Internal data range;
  4. Select required sheet, define range and name;
  5. Press OK to add hyperlink.
4

I have found out that HYPERLINK is not suitable option for building internal links to other cells, as they simply cannot use other cells as reference point. I believe mentioned workaround should be handy for you.

5

The intended use was to build links to external objects (web pages) where a parameter is needed instead of a static URL

6

Can you provide an example? I not sure if this function works this way.

7

Sure:

cell1 value: https://finance.yahoo.com/quote/
cell2 value: AMD
cell3 formula: =hyperlink( cell1 & cell2, cell2)
result: AMD

(I inserted the underscore in “https” because this website was doing something strange to it)

8

You should use CONCAT function inside HYPERLINK function for that to “build”, actually concatenate, text values, for instance:

=HYPERLINK(CONCAT(A1,B1),"page")

In cell A1 I have value http://localhost/ and in B2 subpage, the result of CONCAT function is http://localhost/subpage which is then used in HYPERLINK function is shown above.

1 Like