Text to a Forumla

[jordyosu]

How can I change the following text formula into a formula in Excel

=CONCATENATE("=",Q5,O12,Q6,"'") this comes in as text but I would like to change it to a forumula that is a DDE link.

 

[Jonmo1]

Welcome to the board...

Hard to say really, without knowing the result of the formula...
But I think you would need vba code to do that..

try this, assuming that formula is in A1

Sub Test()
Range("A1").Formula = Range("A1").Value
End Sub

Hope that helps..

 

[Stormseed]

Jonmo, your code seems to convert a formula into a value ? I guess, the OP wants the formula seen formatted as text wants it again to be a formula.

Albeit, I may be all the way wrong coz you are far more experienced then me ! Sorry if I portrayed this one in the wrong way.

 

[DonkeyOte]

I think jonmo's point would be that the "implication" is that this formula extends outside of the workbook in which case using INDIRECT etc becomes inapplicable (if closed) so the VBA approach is the best alternative, however, without knowing the contents of the OP's referenced cells it's difficult for anyone to give a precise response.

 

[Stormseed]

Thanks much for the clarification, Luke. I really appreciate it.

Thanks to you too, Jonmo, atleast for reading my question.

 

[Jonmo1]

Jonmo, your code seems to convert a formula into a value ?

No it converts the Value of the cell into a formula...But again it's hard to tell exactly what the OP wants without more information. Especially ending it with "'".

But just to demonstrate the functionality of the code, remove the "'"

=CONCATENATE("=",Q5,O12,Q6)
If
Q5 = C10
O12 = *
Q6 = E10

Then that formula results in a TEXT string of
=C10*E10

Then my code converts that to a Formula instead of a text string..
Range("A1").Formula = Range("A1").Value

This would convert it to a value
Range("A1").Value = Range("A1").Value

 

[Stormseed]

No it converts the Value of the cell into a formula...But again it's hard to tell exactly what the OP wants without more information. Especially ending it with "'".

But just to demonstrate the functionality of the code, remove the "'"

=CONCATENATE("=",Q5,O12,Q6)
If
Q5 = C10
O12 = *
Q6 = E10

Then that formula results in a TEXT string of
=C10*E10

Then my code converts that to a Formula instead of a text string..
Range("A1").Formula = Range("A1").Value

This would convert it to a value
Range("A1").Value = Range("A1").Value

I did not understand this explanation. I tried but it is raising another 100 questions in my head