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?

​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?  Read More

​