View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default What is the maximum formula lenght??

And that 1024 "limit" can be broken by adding alt-enters every 80-100
characters, too.

JLatham wrote:

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.

"shirley_kee" wrote:


Hi, does anybody knows what is the maximum formula length in a cell??


--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: http://www.excelforum.com/member.php...o&userid=30384
View this thread: http://www.excelforum.com/showthread...hreadid=538727



--

Dave Peterson