Hyperlink Question
Hyperlinks such as: =HYPERLINK(
=HYPERLINK($A$1&B2,"3") works, but don't know how to fix:
=HYPERLINK("webaddress.com="&$A$1,"3") does not.
It goes to the web page, but tries to use: $A$1 as final symbol (not what
is in cell A1, which is desired)
How do I make the 2nd example work? Thanks
|