What is the maximum formula lenght??
 

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

What is the maximum formula lenght??
 

1024 as measured in R1C1 reference style.

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

What is the maximum formula lenght??
 

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

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