Evaluate string as a formula
 

I have this concatentated string in cell D1:

=CONCATENATE("=hyperlink('Sheet1'!C",A1,",""",B1," "")")

Which appropriately creates a string of:
=hyperlink('Sheet1'!C3,"Link me")

My question is this:

How do I get excel to evaluate that string as a formula?

TIA

Heather.


--
peacelittleone


------------------------------------------------------------------------
peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=382267

hi, Heather !

I have this concatentated string in cell D1:
=CONCATENATE("=hyperlink('Sheet1'!C",A1,",""",B1," "")")
Which appropriately creates a string of:
=hyperlink('Sheet1'!C3,"Link me")
My question is this:
How do I get excel to evaluate that string as a formula?

you can use 'directly' in D1: =hyperlink("#'sheet1'!c"&a1,b1)

hth,
hector.

Thank you Hector!

Now a follow-up...,.

The hyperlink doesn't seem to work if the link is in the same workbook
but on a different worksheet. Is there a different function I should
be using?

TIA

Heather.


--
peacelittleone


------------------------------------------------------------------------
peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=382267

Nevermind. I got it.

THANK YOU.

Heather.


--
peacelittleone


------------------------------------------------------------------------
peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=382267