Long formulas (Excel 2000)

  • Thread starter Thread starter Hans Knudsen
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Puzzled by statement about R1C1 style in "Escape from Excel Hell" 3
Two Questions: R1C1 and stop text number converting to data 5
Setting formulas with R1C1 in VBA and eliminate $ 6
Finally, a legitimate Excel 2007 crash 2
converting formula to plain data (number) 2
Named range with multiple groups of cells 4
naming formula 2
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 1

Back
Top