How to turn a string formula into a "real" formula

string excel formula evaluate

Cloaky · Dec 17, 2010 · Viewed 327.3k times · Source

I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?

Answer

Evaluate might suit:

Function Eval(Ref As String)
    Application.Volatile
    Eval = Evaluate(Ref)
End Function