Concatenating 2 column values into 1 column value for multiple rows

  • Thread starter Thread starter Anders S
  • Start date Start date
A

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
 
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.
 
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.
 
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
 
Thank you all very much....it worked great. Never noticed that small square
in the corner before.
 
Back
Top