Wrap text creates an extra line

[Arun]

I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?

 

[Sheeloo]

The behaviour you want is the way Excel is supposed to behave.

What happens if you only enter one word smaller than the Col width? Does
Excel add a blank line too?

Suppose you have this problem in the cell A10
Enter =CLEAN(A10) in A11
Do you get the same problem in A11 too or does it go away?

 

[Arun]

The CLEAN function doesn't make it work right either - but it was a good
idea. The one-word cell causes the same issue. Say the cell width can hold
5 characters without wrapping (the sixth character falls to the next line).
I put in 'xxxxxx' and it appears as
xxxxx
x

Remove one x and I get
xxxxx
(blank line because the row is still 2 lines high)

Remove another x and I still get the blank line. Remove another x (down to
3) and finally it autofits to the correct row height and has a couple spaces
after the word. I am using a basic Arial 10-point font.

 

[Sheeloo]

I am unable to replicate.

Can you mail the file to me?
Excel version? I tested with 2003.

 

[Arun]

I just sent it.

I am unable to replicate.

Can you mail the file to me?
Excel version? I tested with 2003.

 

[Arun]

Actually, I had a delivery notification. What's your address?

 

[Sheeloo]

Click on my name and remove the first part after the @ sign...
I am trying to avoid spammers...

 

[Arun]

I should have gotten that. I sent it again, thanks for your help.