Does there exist an Excel function which will transform a formula into a text string?
For example, if cell B2 contains the formula =B3+1, and I want a text version of this in cell A1, then I want to write '=XXX(B2)' into cell A1, where XXX is the name of this hypothetical function, and this will deliver the result "=B3+1" (i.e. as a text string).
If there isn't such a function, is there a function which will deliver one value if cell B2 contains a number, and a different value if it contains a formula? The closest I can get is the TYPE function, but this doesn't quite do what I want, as it returns a 1 if cell B2 contains either a number OR a formula which returns a number.
Many thanks in advance for any help on this,
DQR