There is a neat trick to do this:
Instead of:
=A1
use
=IF(1=1,A1,HYPERLINK(""))


Obviously 1=1 will always be true. Including the hyperlink call in the If
"tricks" Excel into making the expression a click-able hyperlink.
--
Gary''s Student


"ticu" wrote:

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?