software

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

Try this tiny UDF:Function textit(r As Range) As String
textit = Chr(39) amp; r.Formula
End Function

If A1 has a formula, then =textit(A1) will display it
--
Gary''s Studentquot;Sharonquot; wrote:

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

Put this in a REGULAR code module and then just type =stringit(c4)

Function stringit(x)
stringit = x.Formula
End Function

--
Don Guillett
SalesAid Software

quot;Sharonquot; gt; wrote in message
...
gt; Hi - I would be really grateful if anybody knows a function to return the
gt; formula contained in one cell to another cell as a text string?
gt;
gt; Thanks
gt; --
gt; Sharon
There is no such beast but you can roll your ownwww.mvps.org/dmcritchie/excel/formula.htm

--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Sharonquot; gt; wrote in message
...
gt; Hi - I would be really grateful if anybody knows a function to return the
gt; formula contained in one cell to another cell as a text string?
gt;
gt; Thanks
gt; --
gt; Sharon
Thanks to y'all!! Really hit the spot.
--
Sharonquot;Peo Sjoblomquot; wrote:

gt; There is no such beast but you can roll your own
gt;
gt;
gt; www.mvps.org/dmcritchie/excel/formula.htm
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Sharonquot; gt; wrote in message
gt; ...
gt; gt; Hi - I would be really grateful if anybody knows a function to return the
gt; gt; formula contained in one cell to another cell as a text string?
gt; gt;
gt; gt; Thanks
gt; gt; --
gt; gt; Sharon
gt;
gt;
gt;