J
Joe
Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?
at column or at row. What do I do?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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.
If there's lots of text, add alt-enters every 80-100 characters. You may have
to increase the row height manually.
S
Sean Timmons
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.
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.
J
Joe
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. ?
an expert user but can follow. How do I change the settings you mentioned
below. A2,50 etc. ?
G
Gord Dibben
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
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
S
Sean Timmons
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...
=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...