bbl

If you uncheck "wrap text" do you see a little square box in the text where
the blank line is?

If so, someone entered a new line using ALT + ENTER.

In that case, you can get rid of these boxes by EditReplace

what: hit ALT + 0010(you won't see anything but it's there)
with: nothing

The 0010 must be typed on the NumPad to the right side of keyboard.

Could also be 0013

If can't resolve perhaps David McRitchie's TRIMALL macro will do the trick.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 12:17:03 -0800, bbl wrote:

Unwanted blank line sometimes appears in cell with wrapped text. Editing,
Autofit height and width, and justify do not eliminate it. Forcing column
width to be excessively wide makes it go away, as does reducing the font size
(neither of which I want to do). What's going on? This only happens in some
wrapped text cells.