Evaluates the text in shapename as if it were a formula and returns the result.
EVALTEXT(** shapename!theText ** )
||A cell that is triggered when the associated shape's text composition changes.
shapename can be used to refer to the text of a shape other than the current shape.
If there is no text, the result is zero. If the text cannot be evaluated, the function returns an error.
Evaluates the text contained in the shape Line.2. For example, if Line.2 contains "4 ft + 0.5 ft", returns the value 4.5 ft.