SpreadCE / Spread32

Is there a way to make a formula that shows the text of the formula in another cell?

For example, if B4 contains =SUM(B1:B3)
then I want A4 to display, literally, "=SUM(B1:B3)"

I realize you can do this individually by pressing a series of keys, but I was hoping to do it with a formula of some sort.

(The idea is to make a column that visually documents
the formulas in the column next to it.)

Thanks!

You can do this with a user-defined function.

1) Use the Insert > Macro sheet menu option to insert a macro sheet.

2) Enter the following functions on the macro sheet:
=ARGUMENT("reference",8)
=RETURN(GET.CELL(6,reference))

3) Use the Insert > Name > Define menu option to assign a name to the first cell of the macro, for example "getFormula".

4) Go back to your worksheet and enter your formula like
=getFormula(B4)

I will send you an example file.

Extremely cool --- thanks SO MUCH!