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