If the cells are truly empty...............

Select the column and F5SpecialBlanksOK

EditDeleteShift Up

You could do this on a copy of the column if you want to preserve the
original.


Gord Dibben MS Excel MVP

On Fri, 8 Aug 2008 23:53:01 -0700, Ali Reza <Ali
wrote:

Hi
I have a large column with empty cells and cells with entry.
I want to collect cells with entry in a new smaller column and put out the
empty cells.
Please help me.