| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrap text
i have imported Word text into an Excel cell but it does wrap throughout the
cell. Some of the text wraps correctly and some is truncated. i have set the format to "wrap", i have also set the cell width to the widest possible setting and have adjusted the height to "make fit". The number of characters does not come close to the maximum allowed by excel. any ideas? thanks for your help -- aprilshowers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wrap text
The maximum allowed by Excel is 32767 characters in a cell and these can be
seen in the formula bar. BUT..........Excel will display or print only 1024 characters in the cell. Add an Alt + Enter linefeed every 100 characters to increase this display. Gord Dibben MS Excel MVP On Fri, 14 Nov 2008 13:06:00 -0800, april wrote: i have imported Word text into an Excel cell but it does wrap throughout the cell. Some of the text wraps correctly and some is truncated. i have set the format to "wrap", i have also set the cell width to the widest possible setting and have adjusted the height to "make fit". The number of characters does not come close to the maximum allowed by excel. any ideas? thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
| Wrap text doesn't wrap | Excel Worksheet Functions | |||
| Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
Linear Mode
