| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the text limit for a single cell?
Is their a limit on the number of characters a single cell in Excell will
accept? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the text limit for a single cell?
From Excel help:
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. -- Biff Microsoft Excel MVP "khegedus" wrote in message ... Is their a limit on the number of characters a single cell in Excell will accept? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the text limit for a single cell?
From XL help file article "Excel specifications and limits"
Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Note that you can display more in a cell with the use of line break [Alt+Enter when typing, CHAR(10) when formulas] -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "khegedus" wrote: Is their a limit on the number of characters a single cell in Excell will accept? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the text limit for a single cell?
about 32,000
but you can display about 1024. "khegedus" wrote in message ... Is their a limit on the number of characters a single cell in Excell will accept? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit the number of characters entered in a single cell | Excel Discussion (Misc queries) | |||
| Importing text--cell text limit? | Excel Discussion (Misc queries) | |||
| Display Size Limit In Single Cell | Excel Discussion (Misc queries) | |||
| Can I limit the amount of text in a given cell? | Excel Discussion (Misc queries) | |||
| Limit of text in cell. | Excel Discussion (Misc queries) | |||
Hybrid Mode
