How to combine data from two columns into one column?
 

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

How to combine data from two columns into one column?
 

Try the following if it only regards combining data:


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

Hans


--
hhalle

Male
------------------------------------------------------------------------
hhalle's Profile: http://www.excelforum.com/member.php...o&userid=20829
View this thread: http://www.excelforum.com/showthread...hreadid=499220

How to combine data from two columns into one column?
 

Hi

Try
=A1&B1

If you ever need a space in between, then
=A1&" "&B1

--
Regards

Roger Govier


"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

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