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?

=hyperlink(A1)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"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?