Checkout:

http://www.cpearson.com/excel/noblanks.htm
--
Gary''s Student - gsnu200841


"MikeR-Oz" wrote:

HI,

I have applied a IF statement to Colun H with results in Column I, (thanks
to this group on showing me how) BUt now I would like to condense the
results in Column I to a seperate sheet all together without all the spaces
that are in the I after the IF statement was applied.

Thanks for the extra help.

Mike