View Single Post
  #1   Report Post  
peacelittleone
 
Posts: n/a
Default 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