How much is too much text

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

Mark

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

Gord Dibben

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
 

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

Top