Hyperlink trouble

[ticu]

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?

[David Biddulph]

"ticu" <[email protected]> wrote in message
news:[email protected]...
>
> 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