View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default concatenate problems

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