Dear Mike

Is this what you are looking for..Sheet1 Column I contain your values. You
want to populate the values without spaces to another sheet . Let us say
Sheet2 Col A

To remove the spaces before and after use this in Cell A1
=Trim(Sheet1!I1)

To remove the spaces inbetween the cells use this in Cell A1
=SUBSTITUTE(Sheet1!I1," ","")

If this post helps click Yes
---------------
Jacob Skaria


"MikeR-Oz" wrote:

HI Gary's Student, I have ahd a quick look at the link.

I need the detail from across the other columns (to theleft) of what has
been placed in the last column based on the IF statement. So it seems to me
the array as it shifts the findings up to eliminate spaces would not work. Is
my assumption correct as I need the detail in the columns A - ..up to the IF
column?

Mike

"Gary''s Student" wrote:

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