How to combine data from two columns into one column?

  • Thread starter Thread starter dcnguyen
  • Start date Start date
D

dcnguyen

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"
 
Try the following if it only regards combining data:


A1 = "ABC"
B1 = "DEF"
C1=A1&B1

Hans
 
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
 
Back
Top