"ticu" wrote in message
...

I have a hyperlnk in cell A1.

I want to place a formula in G1 that says:

= A1

When I do that, I get same text as I have in A1, but it does not behave as
a
hyperlink.
I want my cell with formula to behave as hyperlink.

I know I can cut/paste from A1 to G1, that gives me hyperlink in G1.
However, I want to use a formula. Is this possible to do?

Even with a formula in the cell, you can insert a hyperlink as well if you
wish to:
Insert/ Hyperlink
--
David Biddulph