How much is too much text

  • Thread starter Thread starter kelly L
  • Start date Start date
K

kelly L

I am placing narrative in my excel spreadsheet and the
text stops displaying after so many characters in the cell
no matter what I try. I have done the alignment and the
resize of the cell and the Wrap text. The text will not
display text after like 1600 some characters. I am sure
there is a limitation but I can't find anything on it.
All of the text displays in the formula bar but not the
cell.
 
Excel 2000 Help (Search for Limit)

Length of cell contents (text) 32,767 characters.

Only 1,024 display in a cell; all 32,767 display in the
formula bar.
 
Kelly

Excel Help states that "a cell can contain 32,767 characters but only 1024
will be visible or can be printed."

If you set the cell to wrap-text and place some ALT + ENTERS after every few
hundred characters you can get some more characters in the cell.

Before you take Help or my suggestion literally you may find some
enlightenment regarding the limitations of text in a cell in this google
search result.

http://snurl.com/26vl

Gord Dibben Excel MVP
 
Back
Top