Convert cell's text to formula

[dsl224]

Is there a quick way, other than VBA, to put the contents of a cell that has the text of a formula into a second cell, but as a real formula?

What I mean is, if A1 has as text: abs(-1), I would like cell B1 to read the contents of A1 and evaluate it and put the results into B2.

TIA,
David

 

[galileogali]

EVALUATE XLM

I saw the ALADIN answer.
I believe that one does not talk about any UDF.
I believe that one talks about to a ´"Formula with Name", calling a XLM Function like EVALUATE. That is to say, if in A1 there is Formula like STRING, then in for example B1 we are going To insert > Name > Define > Reference To = Evaluate (A1) with Name “FORMULATES”