Excel Formatting Problem

[Venus]

I noticed a problem in a spreadsheet today that I had
encountered prior to Excel 97. This particular problem
appeared to be cured with the introduction of Excel 97.
Now, today, I see the same old problem back with
XP/Windows 2000.

In this spreadsheet, there is a column of cells that have
text in them. However the cell itself does not visually
display all the text that is typed in there. It doesn't
matter if you use Wrap Text, Column Autofit or Row
Autofit, it still doesn't work.

In this particular version of Excel, What you see in the
printed version is often different than what you see on
the screen. I can live with that but I DO need to know
how to correct the problem of Excel not wrapping properly.

Can anyone help?

[Dave Peterson]

Excel's specifications say:

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell;
all 32,767 display in the formula bar. (taken from xl2002's help)

Could you be exceeding the (about) 1024 characters that display?

If your cell is a merged cell, then there is a problem with the rowheight
autofitting.

It looks as though you can actually get significantly more than 1024 characters
to show up in the cell if you provide your own linewrap (char(10)=alt-enter).

Just for testing, I put this in a cell:
="y"&REPT(REPT("asdf ",20) &CHAR(10),30)&"x"
I widened the column and turned wrap text on.
I could see all both the y and x. The length of the text in the cell was 3032.

I put this in another cell:
="y"&REPT("asdf ",275)&"x"
I widened the column to 255. Turned wrap text on and I could see 1377
characters.

But I bet that this has a lot to do with fontsize and font. (I used Arial 10
pt)
(I changed the fontsize and some text disappeared.)

I guess my suggestion is to either work around it (do what looks nice). Maybe
you could use a textbox, too.

--

Dave Peterson
ec3...@msn.com

[Howard]

Do you think you may have maxed out the number of
characters per cell?

>.
>

[msnews.microsoft.com]

I doubt it. There are only about 10 lines of text and the column is about
four inches wide.

Out of curiosity, what IS the max number of characgers per cell?

"Howard" <hs...@dfpray.com> wrote in message
news:07e901c2df5c$0c541ee0$3101...@phx.gbl...

[Gord Dibben]

You can enter 32,767 characters in a cell. Only 1024 will be visible or will
print. 32,767 will show in the formula bar.

Check Help>Index>Specifications for this and other Excel limits.

Gord Dibben Excel MVP - XL97 SR2 & XL2002