Transform array of cell addresses into hyperlinks

Question

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 seem to work. Any suggestions?

jkpieterse · Answer

LazloP&nbsp;Something along these lines should do it:=LET(addresses,TOCOL(A1#),HYPERLINK("#"&amp;addresses))&nbsp;

lazlop · Answer

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 · Answer

LazloP&nbsp;Ouch! My bad, I didn't properly test my suggested solution. It seems the HYPERLINK function isn't "Dynamic array aware".

Forum Discussion

Transform array of cell addresses into hyperlinks

3 Replies

Resources