Like concatenating text?
=concatenate(a1," + ",b2)
or
=concatenate(a1,b2)
=concatenate(a1," ",b2)

"Nigel Ramsden" wrote:

> Is it possible to refer to text in a cell as though it were a formula, ie
> execute it instead of displaying it? Eg if the result of your formula was
> "A1 + B2", to actually add A1 and B2 and display the result?
>
> Thanks
>
> Nigel