software

Word wrap works great for the majority of my document, but for cells
containing more text (over 10 lines or so) the word wrap does not work, and
portions of the text is hidden from view.

Has anyone else experienced this problem?

Thanks,
jc

jeremy

It is not a word-wrap problem.

It is a character-limit per cell problem.

Excel Help on quot;limitsquot; or quot;specificationsquot; reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that quot;only 1024 characters will be visible or can
be printedquot;

To work around this limitation, stick a few ALT ENTERs in at appropriate
spots, about every 100 characters..

The ALT ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

I put this formula in A1:
=quot;xxxquot;amp; REPT(REPT(quot;asdf quot;,25)amp;CHAR(10),58)amp;quot;yyyquot;

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................

Failing that, use a Text Box to store the text or MS Word which is a word
processing application, unlike Excel which is not.Gord Dibben Excel MVP

On Tue, 25 Apr 2006 16:22:02 -0700, jeremy gt;
wrote:

gt;Word wrap works great for the majority of my document, but for cells
gt;containing more text (over 10 lines or so) the word wrap does not work, and
gt;portions of the text is hidden from view.
gt;
gt;Has anyone else experienced this problem?
gt;
gt;Thanks,
gt;jc

Gord Dibben MS Excel MVP

Thanks Gordon. I will try that.
Jeremy

quot;Gord Dibbenquot; wrote:

gt; jeremy
gt;
gt; It is not a word-wrap problem.
gt;
gt; It is a character-limit per cell problem.
gt;
gt; Excel Help on quot;limitsquot; or quot;specificationsquot; reveals that Excel will allow
gt; 32,767 characters to be entered in a cell.
gt;
gt; However, it goes on to state that quot;only 1024 characters will be visible or can
gt; be printedquot;
gt;
gt; To work around this limitation, stick a few ALT ENTERs in at appropriate
gt; spots, about every 100 characters..
gt;
gt; The ALT ENTER forces a line-feed and expands the 1024 limit.
gt;
gt; How far is not really known. Just experiment.
gt;
gt; .........From Dave Peterson..........
gt;
gt; I put this formula in A1:
gt; =quot;xxxquot;amp; REPT(REPT(quot;asdf quot;,25)amp;CHAR(10),58)amp;quot;yyyquot;
gt;
gt; And adjusted the columnwidth, rowheight and font size and I got about 7300
gt; characters to print ok.
gt;
gt; .........End Dave P.................
gt;
gt; Failing that, use a Text Box to store the text or MS Word which is a word
gt; processing application, unlike Excel which is not.
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Tue, 25 Apr 2006 16:22:02 -0700, jeremy gt;
gt; wrote:
gt;
gt; gt;Word wrap works great for the majority of my document, but for cells
gt; gt;containing more text (over 10 lines or so) the word wrap does not work, and
gt; gt;portions of the text is hidden from view.
gt; gt;
gt; gt;Has anyone else experienced this problem?
gt; gt;
gt; gt;Thanks,
gt; gt;jc
gt;
gt; Gord Dibben MS Excel MVP
gt;