This old post should help:

http://tinyurl.com/46af9t

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"FARAZ QURESHI" wrote in message
...
Any idea how to refer to/use the contents of a formula in one cell in
another
formula? For example you can type a formula like:
=Left(A1,5)
Now, suppose if cell A1 contains a formula like =Sum(... ... ...)
How, to get the first five characters of the formula existing in A1, i.e.
"=SUM(" ?
--
Best Regards,
FARAZ A. QURESHI