How to combine data from two columns into one column?

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"
 
H

hhalle

Try the following if it only regards combining data:


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

Hans
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to combine two columns into a new column 2
take some data column into next column ie ABC-DEF-GHI i want DEF 6
Data Matching 2
Combine columns into one column 4
Extracting Data from a string of text in a cell 4
How do I combine the contents of two columns? 4
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
How do I combine two EXCEL columns? 4

Top