How can I calculate a link?

Question

Level 1

9 points

How can I calculate a link?

I know how to create a link on a numbers page. You right click on the text, select Edit Link and put an address in the box. Easy. How about if you want this link to be calculated dynamically? I have a list of domain names and wish to create a dynamic link to perform a whois query, based upon the column with domains in it:

my domain.uk https://www.nominet.uk/whois/?query=0K.UK#whois-results

I can create the URL as a calculation but don't know how to add this as a link. The edit box gives you space for the Link text and the address but does not accept a cell reference.

Posted on Jun 24, 2019 1:54 PM

Reply

Answer 1

Best reply

SGIII

Level 8

35,348 points

Jun 25, 2019 8:17 AM in response to SW11

If you have a list of domain names in column A and you want links in column B that, when clicked, will bring up the whois search results, then you can try something like this:

The formula in B2, filled down, is:

=HYPERLINK("https://www.nominet.uk/whois/?query="&A2&"#whois-results","Link")

Using then HYPERLINK() function means you don't have to manually input link addresses via Edit Link.

SG

Reply

Answer 2

Jun 24, 2019 2:35 PM in response to SW11

I would think you can concatenate the portions together.

If cell A1 contains the domain and column B contains a specific portion of the link then, with data like this:

cell C2 contains the formula:

=HYPERLINK("https://"&A2&"/"&B2,"https://"&A2&"/"&B2)

Reply

Answer 3

SW11 Author

Level 1

9 points

Jun 24, 2019 10:55 PM in response to Wayne Contello

Sorry, not what I meant. I have the URL as a concatenation calculation. What I need is to add that calculation as the link address. In the Link field, when you right click on the link and hit edit link, you can put an address but not the reference to the calculated link.

i was interested if there was any way of doing this.

Reply

Answer 4

SW11 Author

Level 1

9 points

Jun 25, 2019 9:16 AM in response to SGIII

Perfect! I knew it must be possible.

thanks.

Reply

How can I calculate a link?

Similar questions