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