Problem with Text in Excel 2000 Cell

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Not all of the text entered into the cell displays (total
text length is 1,881 characters). Cell is set to text
format, auto-fit row height, alignment-wrap text.

The text that doesn't display is visible in the edit
window, but doesn't show in the cell.
 
From Help

Length of cell contents (text) 32,767 characters.
Only 1,024 display in a cell; all 32,767 display in the formula bar.
 
Ron,

This seems to be the answer. Although in my case 1,201
characters seem to be visible in the cell against 1,881 in
the formula bar.

Thanks.
 
Dave Peterson has previously posted the following advice:

One way to see more than the (about) 1000 characters per cell is to add
a few alt-enters to force linebreaks within the cell.
 
You must log in or register to reply here.

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

Adjusting row height to accomidate text in a cell 2
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
Excel 2003 - Maximum number of characters a cell can contain? 1
wrapping text in merged cells 2
Cells ignore Wrap Text formatting! 2
Text in cell missing when printing 1
Text in a cell 2
Maximum Text in Cells for Printing 1

Back
Top