Select all the cells
Choose EditGo to, and click the Special button
Select Blanks, click OK
Choose EditDelete
Select 'Shift Cells up', click OK

Mario wrote:
Hi
I want to align cells in Excel onto one line.
Example data:

Column1 Column2 Column3 Column4
Row1 ABC
Row2 DEF
Row3 GHI
Row4 JKL

Should be

Column1 Column2 Column3 Column4
Row1 ABC DEF GHI JKL

Thanks a mil




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html