ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrap Text from one cell to another cell (https://www.excelbanter.com/excel-discussion-misc-queries/32003-wrap-text-one-cell-another-cell.html)

bras

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.

bigwheel

"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?

Dave Peterson

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


All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com