Only Part Of Text Displayed In Cell

  • Thread starter Thread starter UT
  • Start date Start date
U

UT

I have long text in a merged cell but on few lines of text are displayed in
the cell. I have to copy the rest of the text in another cell.

Is there certain character length restriction that doesn't display beyond
certain number of characters?

Thanks
 
Excel 2003 and earlier help on specifications states you can have 32767
characters in a cell but by default only 1024 of these will be visible or
printed.

Add and Alt + Enter linefeed every 100 or so characters to get more.

Note: several cells merged into one cell just results in a larger single
cell with the same limitations.


Gord Dibben MS Excel MVP
 
Hi,

the answer is version dependent:

2003 and earlier:
Cells can contain 1024 characters in a formula
Cells can contain 32,767 text characters but only the first 1023 will be
visible (unless you use Alt Enter to force line breaks)

2007:
Cells can contain 8192 characters in formulas
Cells can contain 32,767 text characters in cells and all can be seen and
printed without needing to use Alt Enter.
 

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

Error message is Character Limit is over 1024 characters 2
Text displayed as # in cell 2
Troubleshoot help 3
Excel 2003 - Maximum number of characters a cell can contain? 1
Hide Some Text in a Cell 4
Truncated wrapped text cells in Excel 1
display content of merged cells 1
CSV->Excel Data Problem 1

Back
Top