Viewing ALL text entry for a cell

  • Thread starter Thread starter navajowmn
  • Start date Start date
N

navajowmn

I have a spreadsheet which has a cell with long written descriptions for
item entries in each row. Some descriptions are pretty lengthy and the
cell seems to cut off the text entry once it's reached a particular
length. How can I have the cell display the full text entry? I've got
the cell formatted to wrap text and seems to do fine, until you reach a
certain lenth (character count)??? Is there a max character count in
the cells? If so, can that be changed?? I am using Excel 2000.
 
from Excel XP help -

Length of cell contents (text): 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.
 
CarlosAntenna said:
*from Excel XP help -

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

*
Click to expand...

Thanks
 
If you add alt-enters to force line breaks, you'll be able to see more in that
cell.

(IIRC, I've done this in testing and seen 15k of characters.)
 
Back
Top