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.

JPorter wrote:

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