View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default transfer data from one column into another column

"Transfer" indicates to me that you want to move the data.

Cut and paste the entire column A to Column B

Copy and paste if you want data in A to remain.

Alternative to copy and paste would be to enter =A1 in B1 then
double-click on the fill handle to copy down.


Gord Dibben MS Excel MVP


On Tue, 10 Jan 2006 12:31:05 -0800, Wessel
wrote:

How would you transfer all your data from one column into another column? Eg
from Column A to column B?