The following small UDF will return the formula as string without the = sign:

Function form2text(r As Range) As String
v = r.Formula
form2text = Right(v, Len(v) - 1)
End Function

--
Gary''s Student - gsnu200746


"AccessHelp" wrote:

Hi,

I have a formula "=A00011220" in Cell A1; however, the result of A1 is "A".

In Cells C1, D1 and E1, based on the formula in A1, I want them to show
"A0001", "12" and "20", respectively. The formula in A1 will be the same
format anytime.

Basically, is there a function in Excel that remove the "=" from a formula
and turn it into text or a function that turns the actual formula into text?

Thanks.