ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to combine data from Column A & B (https://www.excelbanter.com/excel-discussion-misc-queries/168075-how-combine-data-column-b.html)

CORaccounting

how to combine data from Column A & B
 
I need to combine Column A & B without doing them individually. Thanks for
the help.

Example
A B Result
1 2 12
3 4 34

David Biddulph[_2_]

how to combine data from Column A & B
 
=A1&B1 and copy down.
--
David Biddulph

"CORaccounting" wrote in message
...
I need to combine Column A & B without doing them individually. Thanks for
the help.

Example
A B Result
1 2 12
3 4 34




excelent

how to combine data from Column A & B
 
Select C1 and type =
now select colum A1:A?
type &
now select column B1:B?
hold CTRL and hit ENTER


"CORaccounting" skrev:

I need to combine Column A & B without doing them individually. Thanks for
the help.

Example
A B Result
1 2 12
3 4 34


CORaccounting

how to combine data from Column A & B
 
Worked perfect, thanks.

"excelent" wrote:

Select C1 and type =
now select colum A1:A?
type &
now select column B1:B?
hold CTRL and hit ENTER


"CORaccounting" skrev:

I need to combine Column A & B without doing them individually. Thanks for
the help.

Example
A B Result
1 2 12
3 4 34



All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com