Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new cell,
all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

hi
loose the double quotes.
=CONCATENATE(M2,K2,N2)

regards
FSt1

"Jeff" wrote:

Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new cell,
all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

Thank you. That did it. (I was copying the example in the "Excel Help")

Jeff

FSt1 wrote:
hi
loose the double quotes.
=CONCATENATE(M2,K2,N2)

regards
FSt1

"Jeff" wrote:

Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new
cell, all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

You did not copy the example correctly.

=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile")

Note: no double quotes around cell references.


Gord Dibben MS Excel MVP

On Sat, 8 Dec 2007 11:47:18 -0500, "Jeff" wrote:

Thank you. That did it. (I was copying the example in the "Excel Help")

Aha!

Gord Dibben wrote:
You did not copy the example correctly.

=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile")

Note: no double quotes around cell references.


Gord Dibben MS Excel MVP

On Sat, 8 Dec 2007 11:47:18 -0500, "Jeff" wrote:

Thank you. That did it. (I was copying the example in the "Excel
Help")

hi,
you're welcome.
and pete had some good ideas too. i just help with your immediate problem ie
what's wrong with this formula?

regards
FSt1

"Jeff" wrote:

Thank you. That did it. (I was copying the example in the "Excel Help")

Jeff

FSt1 wrote:
hi
loose the double quotes.
=CONCATENATE(M2,K2,N2)

regards
FSt1

"Jeff" wrote:

Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new
cell, all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

On Dec 8, 12:30 pm, "Jeff" wrote:
Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new cell,
all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

You can use the & operator instead of the function CONCATENATE (less
typing):

=M2 & K2 & N2

You can separate your text values by a comma and space like so:

=M2&", "&K2&", "&N2

Hope this helps.

Pete

On Dec 8, 12:30 pm, "Jeff" wrote:
Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new cell,
all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

Thanks. Getting rid of the " did the trick.

Jeff

Pete_UK wrote:
You can use the & operator instead of the function CONCATENATE (less
typing):

=M2 & K2 & N2

You can separate your text values by a comma and space like so:

=M2&", "&K2&", "&N2

Hope this helps.

Pete

On Dec 8, 12:30 pm, "Jeff" wrote:
Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new
cell, all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

You're welcome, Jeff - thanks for feeding back.

Pete

On Dec 8, 4:48 pm, "Jeff" wrote:
Thanks. Getting rid of the " did the trick.

Jeff



Pete_UK wrote:
You can use the & operator instead of the function CONCATENATE (less
typing):

=M2 & K2 & N2

You can separate your text values by a comma and space like so:

=M2&", "&K2&", "&N2

Hope this helps.

Pete

On Dec 8, 12:30 pm, "Jeff" wrote:
Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new
cell, all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff- Hide quoted text -

- Show quoted text -