How to delete all the blanc cells in a worksheet and shift cells l

[Guest]

There are a lot of blanc cells in a worksheet, and now I want to select all
of them, delete and shift cells left. is there a function to realize it? or
macro?

Thank you~

 

[Dave Peterson]

Select the range
edit|goto|special|blanks
Edit|delete (shift left)

If you need a macro, you can record one when you do it manually.

 

[T. Valko]

Hit function key F5

Special>Blanks>OK

This will select all blank cells in the used range.

Then:

Edit>Delete>Shift cells left>OK

Biff