removing empty cells

  • Thread starter Thread starter LenC
  • Start date Start date
L

LenC

could someone please help me with this problem.
I have 20 cells in a row but some are empty.
Like so: 10 25 15 18 38 21 17 29 12
How can I put them together in their own cells the
next row down without the empty cells.
Thanks in anticipation.
Len.
 
Select the row, press F5, click special>select blanks, press Ctrl and -
(minus sign ),
select shift cells left.
 
Back
Top