Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Julianne
Possibly you have run up against a limitation of text length. From Excel Help on "specifications" you will learn that you can enter 32767 characters in a cell but only 1024 of them will be visible or can be printed. To work around this limitation, stick a few ALT + ENTERs in at appropriate spots. 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. Gord Dibben Excel MVP On Sat, 21 May 2005 14:07:02 -0700, "Julianne" wrote: Hello - My wrap text is checked, "general" allignment, and my row height is fine, but part of the text in the cell wraps, except my 3rd paragraph - doesn't wrap. I've tried everything. Any suggestions? Thanks, Julianne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Export to fixed width text file | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |