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

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

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

jat

"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

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.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"JPorter" wrote in message
...
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