Formula question from beginner

[JPorter]

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

 

[Dave Peterson]

Make sure your cells are formatted as General (or anything but text), then
reenter the first formula and drag it down.

I've never seen excel behave the way you describe--using a formula like yours.
I'd try it once more.

 

[jatman]

if you copy and paste the formulae in the cells below, it does work.

jat

 

[Earl Kiosterud]

JPorter,

When copied down with the Fill Handle,
=A2&" "&B2
should give you
=A3&" "&B3
=A4&" "B4
etc.

If it isn't, something isn't as advertised. Check the formulas carefully before and after
you drag the Fill Handle. Make sure the A2 reference isn't in quotes or something.