Moving Columns to the Left

[sm2200]

I may be mistaken, but I seem to remember that there was a simple command to move columns with data to the left squeezing out columns without data.

That is if columns B, E, H, I , and M colms had data but columns A, C,D, F,G, J, K, and L had no data, the command would move the data columns to the left so that the result would be columns B,C, D,E, and F would have the data.

Thanks,

Sam Marx

 

[stanleydgromjr]

Sam Marx,

See these links for a macro:
http://exceltips.vitalnews.com/Pages/T0677_Deleting_Blank_Columns.html

http://en.allexperts.com/q/Excel-1059/Delete-Blank-rows-columns-1.htm

Have a great day,
Stan