View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default How to combine data from two columns into one column?

Assuming your data you wish to "combine" is in cells A1 and B1.......then
put this formula in cell C1

=A1&B1

then select B1 and move the cursor to the little black square in the lower
right corrner and click on it and drag it down column C as far as you have
data in columns A and B......let go of the mouse button and the formulas
will be "copied down" column C and will CONCATENATE all the cells in column
A and Column B into column C....

Vaya con Dios,
Chuck, CABGx3


"dcnguyen" wrote in
message ...

Beginner question: Just want to know if there's a quick and easy way to
take the data from one column and append it to another...so, two cells
containing "ABC" and "DEF" respectively would end up as one cell,
"ABCDEF"


--
dcnguyen
------------------------------------------------------------------------
dcnguyen's Profile:

http://www.excelforum.com/member.php...o&userid=30251
View this thread: http://www.excelforum.com/showthread...hreadid=499220