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!
Ron Rosenfeld wrote:
Re: Remove Space in Cells
30-Mar-08
On Sun, 30 Mar 2008 09:24:01 -0700, Rebecca <
[email protected]
wrote
It may be that your column is just a wee bit too narrow, so first widen it jus
a bit; then select the cell or row, click the Home tab, click Format in th
Cells group, and then click AutoFit Row Height
--ron
Previous Posts In This Thread:
Remove Space in Cells
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 ag
our forefathers brought forth...
----------------------------------------
To be or not to be ...
But I want the cells to look like this
For score and seven years ag
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.
Re: Remove Space in Cells
On Sun, 30 Mar 2008 09:24:01 -0700, Rebecca <
[email protected]
wrote
It may be that your column is just a wee bit too narrow, so first widen it jus
a bit; then select the cell or row, click the Home tab, click Format in th
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
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
:
Re: Remove Space in Cells
wrote
If the column width must be fixed, you could adjust these aberrant row height
manually
Another option might be to use a fixed width font
--ron
Re: Remove Space in Cells
Dave
The TRIM function removes extraneous <space> characters. I believe the OP i
concerned about an extra blank line at the bottom of a word-wrapped cell
--ron
Re: Remove Space in Cells
On Mon, 31 Mar 2008 08:50:59 -0700 (PDT), (e-mail address removed) wrote
How would that work, exactly?
As I understand the issue, it is NOT that there are any extraneous character
in the text; rather the problem is how Excel handles the word-wrap when th
column is just slightly too small to accommodate the spacing of the fina
character
--ron
Hi Rebecca,There is a function called TRIM.
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.
Re: Remove Space in Cells
Hi Ron / Rebecca
Perhaps the following then:
=CLEAN(TRIM(A1))
Dave.
Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk Custom Pipeline for Splitting Messages
http://www.eggheadcafe.com/tutorial...6-241d5e325f42/biztalk-custom-pipeline-f.aspx