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.

tiramisu wrote:

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