Text in cells is truncated.
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?
|