Try this tiny UDF:


Function textit(r As Range) As String
textit = Chr(39) & r.Formula
End Function

If A1 has a formula, then =textit(A1) will display it
--
Gary''s Student


"Sharon" wrote:

Hi - I would be really grateful if anybody knows a function to return the
formula contained in one cell to another cell as a text string?

Thanks
--
Sharon