How to concatenate cells

[Greg V]

For instance I want to combine a1 & a2, then a3 & a4 and so on. When
copy the formula I do not get the right cells combined.

In A1 I type =concatenate(A1,A2)

When I copy the formula to cell B1 it is =concatenate(A2, A3)
but I need a3 & a4.

Is there a way to do this?

Thank

 

[Jason Morin]

Put this into B1 and fill across the columns:

=OFFSET($A$1,COLUMN()*2-4,)&OFFSET($A$1,COLUMN()*2-3,)

HTH
Jason
Atlanta, GA

 

[Greg V]

Thanks for your help. I said column instead of rows in my post b
mistake but I was able to understand your idea. Here is what I got t
make it work right.


=OFFSET($A$1,ROW()*2-2,)&OFFSET($A2,ROW()*2-2,)

This puts A1 & A2 in A1, A3 & A4 in A2, etc.

Thanks again!!!
: