Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

Widen the column. Increase the row height?

If there's lots of text, add alt-enters every 80-100 characters. You may have
to increase the row height manually.

Joe wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

--

Dave Peterson

Not sure how much text you have in the cell, but have you tried dragging the
row or column wider? Once you wrap, it may not auto-fit the text.
Antoher option is to have only so much text in each cell.
=Left(A2,50)
then
=mid(A2,51,50)
etc.

Can change the 50 to whatever number of characters you want in the cells.

"Joe" wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

Thanks for your help. I did try expanding both the column and rows. I am not
an expert user but can follow. How do I change the settings you mentioned
below. A2,50 etc. ?

"Sean Timmons" wrote:

Not sure how much text you have in the cell, but have you tried dragging the
row or column wider? Once you wrap, it may not auto-fit the text.
Antoher option is to have only so much text in each cell.
=Left(A2,50)
then
=mid(A2,51,50)
etc.

Can change the 50 to whatever number of characters you want in the cells.

"Joe" wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

Joe

How much text in the cells?

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

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:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

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 Wed, 21 Feb 2007 10:09:05 -0800, Joe wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

well, may be best to explain what the formulas do..

=Left(A2,50)
looks at cell "A2" and returns the first "50" characters.
So, if the text you're workign with is in a different cell, type that cell
in the formula. If you want to have, say, the first 200 characters brought
over, change the 50 to 200.

=mid(A2,51,50)
also looks at cell A2, starts with the 51st character and brings over
through the 100th character. If you were doing 200 characters as above, you'd
type 201,200.

so, if you have multiple cells with the same problem, just type yoru formula
to the right of the first one and decide if you want to drag across your rows
or down your columns.
If you're going across rows, put a $ in front of the A (or whatever column
you're pulling from.)
If down columns, $ in front of the 2 (or whatever row you're pulling from.)

Once you've go the formulas working for your first large cell, copy and
paste them to the right of or below the next big cell.

Hope that made sense...

"Joe" wrote:

Thanks for your help. I did try expanding both the column and rows. I am not
an expert user but can follow. How do I change the settings you mentioned
below. A2,50 etc. ?

"Sean Timmons" wrote:

Not sure how much text you have in the cell, but have you tried dragging the
row or column wider? Once you wrap, it may not auto-fit the text.
Antoher option is to have only so much text in each cell.
=Left(A2,50)
then
=mid(A2,51,50)
etc.

Can change the 50 to whatever number of characters you want in the cells.

"Joe" wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?