![]() |
Is there a character maximum per cell
I was wondering if there is a maximum number of characters you can have in a
cell? -- DMM |
Is there a character maximum per cell
On Fri, 6 Mar 2009 05:16:02 -0800, soconfused
wrote: I was wondering if there is a maximum number of characters you can have in a cell? Yes there is, and it may be different in different versions. Check HELP for Specifications and Limits. --ron |
Is there a character maximum per cell
Hi,
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. have a loo here for Excel specifications and limits http://office.microsoft.com/en-us/ex...992911033.aspx Mike "soconfused" wrote: I was wondering if there is a maximum number of characters you can have in a cell? -- DMM |
Is there a character maximum per cell
Hi Soconfused,
Just checked.. in excel 2003 you can enter "32767" characters in a cell. Thanks, -- Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "soconfused" wrote: I was wondering if there is a maximum number of characters you can have in a cell? -- DMM |
Is there a character maximum per cell
You can see more than the 1000 or so characters documented in xl's help by
adding alt-enters (to force new lines within the cell) every 80-100 characters. Mike H wrote: Hi, 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. have a loo here for Excel specifications and limits http://office.microsoft.com/en-us/ex...992911033.aspx Mike "soconfused" wrote: I was wondering if there is a maximum number of characters you can have in a cell? -- DMM -- Dave Peterson |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com