Viewing ALL text entry for a cell

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

CarlosAntenna

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

navajowmn

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
 
D

Dave Peterson

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.)
 
Top