Wrap Text from one cell to another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
bras said:
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.
Click to expand...

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?
 
If you add alt-enters every 80-100 characters, you can extend that documented 1k
characters that are visible in a cell.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell format - wrap text 7
Excel VBA 1
Merged cells stop wrapping 4
wrap text 1
Expanding Capabilities of Wrap Text in a cell 1
Merged cell text does not wrap 1
Cells ignore Wrap Text formatting! 2
Cannot save text wrapping in cells-must do individually 1

Back
Top