Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I stop my text being truncated at RHS of a cell? | Excel Discussion (Misc queries) | |||
Truncated text using vlookup to linked worksheet | Excel Discussion (Misc queries) | |||
Truncated wrapped text cells in Excel | Excel Discussion (Misc queries) | |||
Text Truncated on Vertical Chart Axis Label | Excel Discussion (Misc queries) | |||
Truncated text when copying text from one excel doc to another | Excel Discussion (Misc queries) |