Select the B entries; copy
Move to A1 and use Paste
If you turn on Macro Record (Tools | Macros | Record Macro) before you do
this, then you will make a macro that will do it for you next time.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"John" wrote in message
...
Hi Guys.
this is the sample that I got:
A B C D
------------------------------------------------------------
row john 158 258
2 mike 125 236
3 ted 258 235
4 may 258 2358
5 joy 268 258
6 mary 258 269

how to move column B to A and keep the row#4,6 no change, I can do it manu
but I need is formula or macro for many joys.


"Gord Dibben" wrote:

John

A:A is one column so you can't delete empty columns in a column.

What exactly do you want to do?

Delete blank rows in column A?

How does column B fit into this?


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 11:54:03 -0800, John
wrote:

how to (forumla or macro) delete only the empty columns in A:A, but if
any
text in A10 or A18 not empty then need to keep it, after the empty box
deleted the column B need to move to A