View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] gerry.lisa@gmail.com is offline
external usenet poster
 
Posts: 31
Default 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