| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum value in a cell | Excel Discussion (Misc queries) | |||
| Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
| maximum value of a cell | Excel Discussion (Misc queries) | |||
| Maximum value of a cell | Excel Discussion (Misc queries) | |||
| Maximum Value in a Cell | Excel Discussion (Misc queries) | |||
Linear Mode
