Bernard,

Thanks for below function. Is there a way to do it using just standard
Excel function, ie, entering Excel formula in the formula bar?

Ben
--



"Bernard Liengme" wrote:

Here is a user-defined function that will do what you want

Function showfn(mycell)
If mycell.HasFormula Then
showfn = Mid(mycell.Formula, 2)
Else
showfn = ""
End If
End Function

Need help using it?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ben" wrote in message
...
Hi all,

Is there a way to "Textualize" a forumula from another cell usinig
standard
Excel built-in text functions? For example

A1 B1 C1 D1
1 2 3 [A1+B1]

cell D1 gets it's value from C1 which contains a formula: [=A1+B1]. But
in
D1 the "=" is stripped.

Thanks.

Ben


--