View Single Post
  #1   Report Post  
Jambruins
 
Posts: n/a
Default Getting rid of empty cells

I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting
and pasting. I have a lot of values and empty cells so if there is a formula
that would be a lot quicker than cutting and pasting. Thanks.