Cell word wrap.

  • Thread starter Thread starter Carl Gross
  • Start date Start date
C

Carl Gross

I have Office 97, SR-1a.

In a cell that has 1801 characters, the text quits
wrapping and keeps going off to the right hand side of the
cell.

This happens again with a cell that has 1530 characters in
it. Is there an issue with Excel that would make it do
that?

How do I make it stop doing that and make it wrap normally?
 
I have Office 97, SR-1a.

In a cell that has 1801 characters, the text quits
wrapping and keeps going off to the right hand side of the
cell.

This happens again with a cell that has 1530 characters in
it. Is there an issue with Excel that would make it do
that?

How do I make it stop doing that and make it wrap normally?
Click to expand...

G'day Carl,

I had a similar problem with Excel2k and read somewhere (can't
find the reference at present) that Excel can handle up to
32,767 characters but will only display 1024 so I now paste in a
text box from Word.

Cheers,
Julian

--
Julian Mattay, email: julian x mattay z csiro x au
(where x -> dot, z -> at)
Local IT Bloke
CSIRO, Forestry and Forest Products Ph: +61 8 8721 8118
Mt Gambier, South Australia, Australia Fax: +61 8 8723 9058
 
You can have a cell that contains about 32k worth of characters, but left to its
own devices, excel will only show about 1000.

You can add alt-enters to force new lines within your cell and you can see more.
 
Back
Top