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?

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?

Since you want TRUE you can just put it there

=IF(TRUE,A1,HYPERLINK(""))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Gary''s Student" wrote in message
...
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?