Concatenate function not working for me
 

I'm using InsertFunctionConcatenate and using the wizard

text 1 I'm clicking on the first cell I want to concatenate L2

text 2 I'm typing in ", " (without the quotes)

text 3, I'm clicking on the 2nd cell I want to concatenate M2

then enter

I'm getting =CONCATENATE(L2,", ",M2) in N2 as opposed to "text in
first cell, text in second cell"

What am I doing wrong?

....Lisa XL03

Concatenate function not working for me
 

Check that your cell is not formatted as text.
Right-click cell, Format Cells- Number tab. Set to General.

HTH,
Paul

wrote in message
oups.com...
I'm using InsertFunctionConcatenate and using the wizard

text 1 I'm clicking on the first cell I want to concatenate L2

text 2 I'm typing in ", " (without the quotes)

text 3, I'm clicking on the 2nd cell I want to concatenate M2

then enter

I'm getting =CONCATENATE(L2,", ",M2) in N2 as opposed to "text in
first cell, text in second cell"

What am I doing wrong?

...Lisa XL03

Concatenate function not working for me
 

That did it Paul!
Thanks!!

....Lisa

On Jun 29, 10:43 am, "PCLIVE" wrote:
Check that your cell is not formatted as text.
Right-click cell, Format Cells- Number tab. Set to General.

HTH,
Paul

wrote in message

oups.com...

I'm using InsertFunctionConcatenate and using the wizard

text 1 I'm clicking on the first cell I want to concatenate L2

text 2 I'm typing in ", " (without the quotes)

text 3, I'm clicking on the 2nd cell I want to concatenate M2

then enter

I'm getting =CONCATENATE(L2,", ",M2) in N2 as opposed to "text in
first cell, text in second cell"

What am I doing wrong?

...Lisa XL03