| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Macro to compare two columns of data | Excel Discussion (Misc queries) | |||
| Macro to compare two columns of data | Excel Discussion (Misc queries) | |||
| Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
Linear Mode
