Select Column A and F5SpecialBlanksOK

EditDeleteShift cells left.


Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 04:43:14 -0400, smash123
wrote:


Hello everyone, I have an excel problem please help me if you can.

I have ‘Apple’ in A1 and ‘Orange’ in B2

Looks like this in excel:

Apple(A1)
Orange(B2)

I need to move B2 ‘Orange’ to column A at the same row which is A2
while not remove ‘Apple’. A2 is empty space. Here is the result I
need:

Apple(A1)
Orange(A2)


I’m facing about 5000 row of this kind of data. Please let me know any
shortcut way to do this. Thank you very much!!