Evaluate string as a formula

[peacelittleone]

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

 

[Héctor Miguel]

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.

 

[peacelittleone]

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]

Nevermind. I got it.

THANK YOU.

Heather.