What is the maximum formula lenght??

  • Thread starter Thread starter shirley_kee
  • Start date Start date
S

shirley_kee

Hi, does anybody knows what is the maximum formula length in a cell??
 
In Excel 2003 the maximum number of characters in a cell is 32,767, all of
which will show up in the formula bar, but only 1024 will show up in the cell
itself.

Check out 'Worksheet and workbook specifications' in Excel help for your
specific version of Excel.
 
And that 1024 "limit" can be broken by adding alt-enters every 80-100
characters, too.
 
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

fixed cell lenght 1
Max Formula Lenght 3
Excel 2003 maximum formula length 10
Formula for showing warnings when cells are out of range. 1
Prevent invalid data when pasting from Word directly onto cell? 3
Excel Calculating arched beam surface area and volume on excel 3
cell lenght MUST be always 30 8
How to convert number in to time lenght, minutes and seconds? 3

Back
Top