Hi,

I am trying to apply the CONCATENATE formula to some cells.

More specifically, I am trying to combine the text from two columns into one.

I write the formula as =A2&" "&B2 and that works great.

What I would like to know is how I can apply this same formula to other
cells (in other words I want A3 & B3, A4 &B4, A5 & B5 and so forth and so
on).

If I just drag the formula the only value that changes is the second. (So
if i start out with =A2&" "&B2 and then drag it down, the next cell formula
is =A2&" "&B3


Can anyone help this beginner?

Thanks so much.

JPorter