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.

[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.

[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.

[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.

[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.

[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.

[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.

[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.

[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.

[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.

[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.

[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.