Concatenating 2 column values into 1 column value for multiple rows

[Anders S]

Hi,

In C1 enter
=CONCATENATE(A1,B1)
or shorter
=A1&B1

Then select C1 and drag the little black square in the bottom right corner of the cell down as far as needed. The formula will adjust automatically.

HTH
Anders Silven

 

[Frank Kabel]

Hi
simply enter the following in C1
=A1&B1
and then copy/drag this formula down for all rows. The row index will
change automatically.

 

[eVeNtHoRiZoN]

I did a search in this forum for "concatenate" in the subject but could not
find any results.
Sorry if this has already been answered.

I have 2 columns with 208 rows each...I would like to concatenate each
column value (with the row as the index)...for example

A1:A5 is 100, 200, 300, 400, 500
B1:B5 is 1, 2, 3, 4, 5

I would like C1:C5 to be 1001, 2002, 3003, 4004, 5005

Without using a various concatenates for each cell (e.g. C1=Concatenate(A1,
B1), C2=Concatenate(A2, B2),etc)...I am looking for a single formula that
could be pasted in each cell for column C and produce the correct result. I
would also like to avoid macros.

I have been experimenting with the ROW() - which alone gives me the row
number, but I cannot seems to use it for the wild card on each row index.
For example,
Concatenate(A(Row()), B(Row())) ---in an attempt to produce A1,B1...A2,B2 in
my concatenate statement.

Can someone point me in the right direction?

Thanks in advance.

 

[Gord Dibben]

How about in C1.....

=(A1&B1)*1

The *1 makes the result numeric. If you just want text, leave it off.

Double-click on the fill handle to increment down Column C.

Gord Dibben Excel MVP

 

[Excel Newbie]

Thank you all very much....it worked great. Never noticed that small square
in the corner before.