What is the text limit for a single cell?

T

T. Valko

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.
 
L

Luke M

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

limit of characters in Excell 1
Limit the number of characters entered in a single cell 4
limit # of chars in a cell 1
How do you find out how many cell styles you have in a workbook? 1
How to limit the number of characters in a cell? 5
Cell Formats - Limit # of characters 3
cell character limit 8
limit number of characters in cell 4

Top