Forum Discussion

Copper Contributor

Nov 04, 2024

Transform array of cell addresses into hyperlinks

I need some help here... I have an array of cell addresses as input, which I would like to transform into an array of hyperlinks. Like this: I tried HYPERLINK(A1#), but that doesn't see...

excel

Formulas and Functions

JKPieterse

Silver Contributor

Nov 04, 2024

LazloP Something along these lines should do it:

=LET(addresses,TOCOL(A1#),HYPERLINK("#"&addresses))

LazloP

Copper Contributor

Nov 04, 2024

Thanks... your formula indeed creates an array of hyperlinks. However, when clicking on them, they all take me to the address of the first cell (R3C5), even though the hyperlinks show different addresses.

JKPieterse
Silver Contributor
Nov 04, 2024
LazloP Ouch! My bad, I didn't properly test my suggested solution. It seems the HYPERLINK function isn't "Dynamic array aware".