Greetings, again. I hope I'm not getting too annoying by posting so often,
but I can't solve this problem on my own. I am using MS Excel 2007. I have a
column with cells full of text, the word count of which is of various length.
The cells are aligned (horizontal) left (indent) and (vertical) top. The text
control is wrap text.

The problem is that some cells have spaces between the end of the text in
the above cell and the beginning of the next cell below. To help visualize
this:
___________________________
For score and seven years ago
our forefathers brought forth....

-----------------------------------------
To be or not to be ....

But I want the cells to look like this:

For score and seven years ago
our forefathers brought forth....
------------------------------------------
To be or not to be ....

Format autofit row height does not remove this extra space at the bottom of
some cells. Do any of the experts have any suggestions? Please remember that
most of the cells are OK. That is, there is no waste of space between the
cells. Thanks.

On Sun, 30 Mar 2008 09:24:01 -0700, Rebecca
wrote:

Greetings, again. I hope I'm not getting too annoying by posting so often,
but I can't solve this problem on my own. I am using MS Excel 2007. I have a
column with cells full of text, the word count of which is of various length.
The cells are aligned (horizontal) left (indent) and (vertical) top. The text
control is wrap text.

The problem is that some cells have spaces between the end of the text in
the above cell and the beginning of the next cell below. To help visualize
this:
___________________________
For score and seven years ago
our forefathers brought forth....

-----------------------------------------
To be or not to be ....

But I want the cells to look like this:

For score and seven years ago
our forefathers brought forth....
------------------------------------------
To be or not to be ....

Format autofit row height does not remove this extra space at the bottom of
some cells. Do any of the experts have any suggestions? Please remember that
most of the cells are OK. That is, there is no waste of space between the
cells. Thanks.

It may be that your column is just a wee bit too narrow, so first widen it just
a bit; then select the cell or row, click the Home tab, click Format in the
Cells group, and then click AutoFit Row Height.

--ron

Thanks, Ron, but I don't want to change the column width, so I guess I'm out
of luck. And even if I did change it, wouldn't that produce other cells that
would have "wasted space" at the bottom of the cells? Then I would have to
adjust the width again, and ... well, you get the picture.

"Ron Rosenfeld" wrote:

On Sun, 30 Mar 2008 09:24:01 -0700, Rebecca
wrote:

Greetings, again. I hope I'm not getting too annoying by posting so often,
but I can't solve this problem on my own. I am using MS Excel 2007. I have a
column with cells full of text, the word count of which is of various length.
The cells are aligned (horizontal) left (indent) and (vertical) top. The text
control is wrap text.

The problem is that some cells have spaces between the end of the text in
the above cell and the beginning of the next cell below. To help visualize
this:
___________________________
For score and seven years ago
our forefathers brought forth....

-----------------------------------------
To be or not to be ....

But I want the cells to look like this:

For score and seven years ago
our forefathers brought forth....
------------------------------------------
To be or not to be ....

Format autofit row height does not remove this extra space at the bottom of
some cells. Do any of the experts have any suggestions? Please remember that
most of the cells are OK. That is, there is no waste of space between the
cells. Thanks.

It may be that your column is just a wee bit too narrow, so first widen it just
a bit; then select the cell or row, click the Home tab, click Format in the
Cells group, and then click AutoFit Row Height.

--ron

On Sun, 30 Mar 2008 15:23:00 -0700, Rebecca
wrote:

Thanks, Ron, but I don't want to change the column width, so I guess I'm out
of luck. And even if I did change it, wouldn't that produce other cells that
would have "wasted space" at the bottom of the cells? Then I would have to
adjust the width again, and ... well, you get the picture.

If the column width must be fixed, you could adjust these aberrant row heights
manually.

Another option might be to use a fixed width font.



--ron

Hi Rebecca,
There is a function called TRIM. It removes all spaces from a text
except single spaces between words.
If your texts start at A1, use a blank column, eg Column B and insert
=TRIM(A1)
Copy down to the end of your text cells.
You could then select all the trimmed cells in column B, copy, select
A1, Paste Special, Values, then delete the contents of column B.
Regards - Dave.

On Mon, 31 Mar 2008 06:35:02 -0700 (PDT), wrote:

Hi Rebecca,
There is a function called TRIM. It removes all spaces from a text
except single spaces between words.
If your texts start at A1, use a blank column, eg Column B and insert
=TRIM(A1)
Copy down to the end of your text cells.
You could then select all the trimmed cells in column B, copy, select
A1, Paste Special, Values, then delete the contents of column B.
Regards - Dave.

Dave,

The TRIM function removes extraneous <space characters. I believe the OP is
concerned about an extra blank line at the bottom of a word-wrapped cell.
--ron

Hi Ron / Rebecca
Perhaps the following then:
=CLEAN(TRIM(A1))
Dave.

On Mon, 31 Mar 2008 08:50:59 -0700 (PDT), wrote:

Hi Ron / Rebecca
Perhaps the following then:
=CLEAN(TRIM(A1))
Dave.

How would that work, exactly?

As I understand the issue, it is NOT that there are any extraneous characters
in the text; rather the problem is how Excel handles the word-wrap when the
column is just slightly too small to accommodate the spacing of the final
character.
--ron

One behaviour I have noticed on my spreadsheet is that it only does it with cells where I have included a line break. Removing the line break removes the space at the end of the cell, and adding the line break back in causes the space to return at the end of the cell. Obviously a bug with Microsoft's code.

Apologies for posting to an old post, but thought this tidbit of information might help somebody. :-)

On Sunday, March 30, 2008 12:24 PM Rebecc wrote:

Greetings, again. I hope I'm not getting too annoying by posting so often,
but I can't solve this problem on my own. I am using MS Excel 2007. I have a
column with cells full of text, the word count of which is of various length.
The cells are aligned (horizontal) left (indent) and (vertical) top. The text
control is wrap text.

The problem is that some cells have spaces between the end of the text in
the above cell and the beginning of the next cell below. To help visualize
this:
___________________________
For score and seven years ago
our forefathers brought forth....

-----------------------------------------
To be or not to be ....

But I want the cells to look like this:

For score and seven years ago
our forefathers brought forth....
------------------------------------------
To be or not to be ....

Format autofit row height does not remove this extra space at the bottom of
some cells. Do any of the experts have any suggestions? Please remember that
most of the cells are OK. That is, there is no waste of space between the
cells. Thanks.


On Sunday, March 30, 2008 2:01 PM Ron Rosenfeld wrote:

On Sun, 30 Mar 2008 09:24:01 -0700, Rebecca
wrote:


It may be that your column is just a wee bit too narrow, so first widen it just
a bit; then select the cell or row, click the Home tab, click Format in the
Cells group, and then click AutoFit Row Height.

--ron


On Sunday, March 30, 2008 6:23 PM Rebecc wrote:

Thanks, Ron, but I don't want to change the column width, so I guess I'm out
of luck. And even if I did change it, wouldn't that produce other cells that
would have "wasted space" at the bottom of the cells? Then I would have to
adjust the width again, and ... well, you get the picture.

"Ron Rosenfeld" wrote:


On Sunday, March 30, 2008 7:51 PM Ron Rosenfeld wrote:

wrote:


If the column width must be fixed, you could adjust these aberrant row heights
manually.

Another option might be to use a fixed width font.



--ron


On Monday, March 31, 2008 11:14 AM Ron Rosenfeld wrote:

Dave,

The TRIM function removes extraneous <space characters. I believe the OP is
concerned about an extra blank line at the bottom of a word-wrapped cell.
--ron


On Monday, March 31, 2008 12:00 PM Ron Rosenfeld wrote:

On Mon, 31 Mar 2008 08:50:59 -0700 (PDT), wrote:


How would that work, exactly?

As I understand the issue, it is NOT that there are any extraneous characters
in the text; rather the problem is how Excel handles the word-wrap when the
column is just slightly too small to accommodate the spacing of the final
character.
--ron


On Wednesday, April 02, 2008 12:38 AM elietebonallac wrote:

Hi Rebecca,
There is a function called TRIM. It removes all spaces from a text
except single spaces between words.
If your texts start at A1, use a blank column, eg Column B and insert
=TRIM(A1)
Copy down to the end of your text cells.
You could then select all the trimmed cells in column B, copy, select
A1, Paste Special, Values, then delete the contents of column B.
Regards - Dave.


On Wednesday, April 02, 2008 12:38 AM elietebonallac wrote:

Hi Ron / Rebecca
Perhaps the following then:
=CLEAN(TRIM(A1))
Dave.


On Wednesday, April 07, 2010 12:25 PM Scott Smith wrote:

The issue of extra space at the bottom of some Excel 2007 when using word wrap is very annoying. I'm an advanced user of Excel and can't find any easy way to eliminate the spaces. At first I thought all the extra spaces were the same, but no, they are random sizes. Making the column wider doesn't solve the problem. Increasing the font size helps some but may not be an option. TRIM is too unwieldy and doesn't work either.



I can manually adjust the bottom of each cell to cover up some text on the screen display in order to eliminate space when printing but that seems stupid and self-defeating.



Someone out there has bound to have solved this. Please help!