| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| formula that includes a maximum amount | Excel Worksheet Functions | |||
Linear Mode
