Number of characters per cell

[Vivian Carroll]

A friend sent me a file that she swears was created and modified only in
Excel 2000. However, there is one cell with a lot of text in it that appears
to be showing only the first 255 characters (I didn't count, just guessed at
the number). I believe that although Excel 97 allowed only 255 characters
per cell, Excel 2000 allows up to 65,000 characters. The cell is formatted
General, left aligned, wrapped, vertically centered and the row height is at
the maximum of 407 - but visually there is room for more text in the
row/cell (above and below the vertically centered text), but the text
doesn't appear.

Any ideas?

TIA, Vivian

 

[Dave Peterson]

Ah, ha. So it wasn't truncated really.

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.

But xl says that you can only see 1024 characters per cell (if you don't add
those alt-enters).

 

[Dave Peterson]

Did you widen the column?
Did you extend the row height?

Maybe setting them manually will help. I think I've seen up to 15k in a cell
with no trouble (then got bored).

Thanks for the suggestion Dave. However, I tried the Alt+Enters but I still
can't see everything in the cell!

Vivian