dianemarie
Instructor
Hello, is there any way to get Excel to display more then 1,024 characters of text in one cell? Or is this just a limitation that we can't change. The cell is currently in General format. Thank you!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Cell Specifications for Max Length of Text
- Thread starter dianemarie
- Start date
- Status
From excel help:
Maximum length of cell contents (text) 32,000 characters
Maximum length of formula contents 1,024 characters
Although you can have 32000 chars, you can only display a limited number of them in the cell itself (256 I think) - you can see the full text in the formula bar however
HTH
~Geoff~
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Maximum length of cell contents (text) 32,000 characters
Maximum length of formula contents 1,024 characters
Although you can have 32000 chars, you can only display a limited number of them in the cell itself (256 I think) - you can see the full text in the formula bar however
HTH
~Geoff~
- Status
Similar threads
- Locked
- Question