>> Text Wrap

  • Thread starter Thread starter Jonathan Parminter
  • Start date Start date
J

Jonathan Parminter

Hi, I know that excel is not a word processing
application. But a user has decided to utilise the table
layout of Excel (v 2002).

The problem is that for at least one cell the wrapping
feature is not working completely. That is, text wraps
upto line 5. From then on lines are truncated.

Each line is a single sentence (using Alt+ENTER).
Admittedly some are rather verbose!

Is this a limitation with text wrapping or is there
something that I can do to resolve this issue?

Any ideas or suggestions appreciated :-)

Thanks
Jonathan
 
Sometimes when I have long text in cells with alt-enters, the text actually
wraps correctly, but the rowheight doesn't automatically adjust.

I just resize the rowheight to see all the cell's content.
 
Thanks Dave,

When I adjust the row height further there is no
additional adjustment to the text. That is, only the first
5 lines of text wrap. Subsequent lines just disappear from
view when the text gets to the cell border (there is no
content in adjacent cell).

Between the last line of text and the bottom of the cell
is just empty space.

Jonathan
 
How many alt-enters have you added (and in what positions in the string).

And how long is that string (=len(a1) will give you the length)

And what version of excel are you using?

(I'd add a few more alt-enters to force the newline where I wanted them--don't
let excel do it--just to test.)
 
Back
Top