Long formulas (Excel 2000)

H

Hans Knudsen

Hello
I was just trying how long a formula (R1C1 style) I could enter into a cell (A10). I entered =R1C1+R1C1 .... (less than 1024
characters) and then I tried:

=LEN(A10)

Result: 1

Not quite obvious to me what's going on.

Hans Knudsen
 
H

Hans Knudsen

Please forget about the above post. I realized that I had forgotten to change my formula to a text string before using the LEN
function.

Hans
 
Top