Want one cell to show hyperlink from other cell
 

I'm trying to use this function =IF(TRUE,A1,HYPERLINK("")) to simply
have one cell show the other cell which contains a hyperlink. When I
use this code, the text shows, but the hyperlink does not and when I
click, it says site not found. How can I get this to work?


--
Billznik
------------------------------------------------------------------------
Billznik's Profile: http://www.excelforum.com/member.php...o&userid=37119
View this thread: http://www.excelforum.com/showthread...hreadid=568728

Want one cell to show hyperlink from other cell
 

Billznik wrote:
I'm trying to use this function =IF(TRUE,A1,HYPERLINK("")) to simply
have one cell show the other cell which contains a hyperlink. When I
use this code, the text shows, but the hyperlink does not and when I
click, it says site not found. How can I get this to work?



Hi Billznik,

I think you could find useful these pages about hyperlinks in Excel:

http://office.microsoft.com/en-gb/as...995161033.aspx

http://office.microsoft.com/en-gb/as...091161033.aspx

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy