As we all know, the max characters that Excel can store in a cell is
32,767.  As we all THINK we know (because Microsoft tells us so), the
max characters that Excel will display or print is 1024.  However, this
is just wrong.  I have a spreadsheet that includes cells with some very
large text strings (a glossary tab, actually).  In many of the cells of
this spreadsheet more than 1,300 characters display and in one of them
approximately 5,500 characters are displayed!!  But here's the rub...
within various cells certain sentences or paragraphs are truncated.  Of
course, if the particular sentence that gets truncated is the last
sentence then it would appear that the text is truncating because it is
too long to be displayed in the cell... but I am skeptical of that
because so many of the cells display very many more characters.

To observe this bizzzzaar phenomenon, you can download a sample
workbook with examples of two cells that exhit the behavior described
here:

http://sodogroup.com/downloads/BigTextCellSamples.xls

The workbook has only one worksheet in it and no macros so you won't
need to worry about virues or any such things.  Alternatively, I have
posted a graphic of the two cells here:

http://sodogroup.com/downloads/BigTextCellSamples.gif

Can you solve the mystery?  

Thanks,

Bob