Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Wrap Text from one cell to another cell
I want type all my text into C111 (1-3 pages worth). I want this text to
automatically wrap to D111 to E111 to F111 to G111, etc. The cell appears to have a maximum limit of characters. Please help. |
#2
|
|||
|
|||
"bras" wrote:
I want type all my text into C111 (1-3 pages worth). I want this text to automatically wrap to D111 to E111 to F111 to G111, etc. The cell appears to have a maximum limit of characters. Copied from the help file:- Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Have you considered putting your text in a textbox? |
#3
|
|||
|
|||
If you add alt-enters every 80-100 characters, you can extend that documented 1k
characters that are visible in a cell. bras wrote: I want type all my text into C111 (1-3 pages worth). I want this text to automatically wrap to D111 to E111 to F111 to G111, etc. The cell appears to have a maximum limit of characters. Please help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |