software

A cell contains several paragraphs of text. Only the first dozen or so lines
of text wrap. The rest doesn't wrap and each following paragraph can only be
seen partially.


I would try the following:
Select the column or Cell and go to quot;FORMAT CELLSquot; select quot;Alignmentquot; -
quot;Vertical Alignmentquot; - then select quot;TOPquot; and also ensure the quot;WORD WRAP
box is checked.
The default is usuall quot;bottomquot; and then if you have a narrow row - it
will sometimes only show the first line.

You might also have some paragraph returns entered. Insert a column
next to the column that needs to be quot;Cleanedquot; and then select the
quot;CLEANquot; Function and then select the cell you want to quot;CLEANquot;--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=495656Thanks, It still doesn't wrap all when the amount of text gets too big.

quot;wjohnsonquot; wrote:

gt;
gt; I would try the following:
gt; Select the column or Cell and go to quot;FORMAT CELLSquot; select quot;Alignmentquot; -
gt; quot;Vertical Alignmentquot; - then select quot;TOPquot; and also ensure the quot;WORD WRAP
gt; box is checked.
gt; The default is usuall quot;bottomquot; and then if you have a narrow row - it
gt; will sometimes only show the first line.
gt;
gt; You might also have some paragraph returns entered. Insert a column
gt; next to the column that needs to be quot;Cleanedquot; and then select the
gt; quot;CLEANquot; Function and then select the cell you want to quot;CLEANquot;
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=495656
gt;
gt;

Kris

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 Thu, 22 Dec 2005 21:06:03 -0800, quot;Krisquot; gt;
wrote:

gt;Thanks, It still doesn't wrap all when the amount of text gets too big.
gt;
gt;quot;wjohnsonquot; wrote:
gt;
gt;gt;
gt;gt; I would try the following:
gt;gt; Select the column or Cell and go to quot;FORMAT CELLSquot; select quot;Alignmentquot; -
gt;gt; quot;Vertical Alignmentquot; - then select quot;TOPquot; and also ensure the quot;WORD WRAP
gt;gt; box is checked.
gt;gt; The default is usuall quot;bottomquot; and then if you have a narrow row - it
gt;gt; will sometimes only show the first line.
gt;gt;
gt;gt; You might also have some paragraph returns entered. Insert a column
gt;gt; next to the column that needs to be quot;Cleanedquot; and then select the
gt;gt; quot;CLEANquot; Function and then select the cell you want to quot;CLEANquot;
gt;gt;
gt;gt;
gt;gt; --
gt;gt; wjohnson
gt;gt; ------------------------------------------------------------------------
gt;gt; wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
gt;gt; View this thread: www.excelforum.com/showthread...hreadid=495656
gt;gt;
gt;gt;