View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gav123 Gav123 is offline
external usenet poster
 
Posts: 136
Default Combining data from multiple cells into one cell.

=(C4&""&D4)


"RFJ" wrote:


=concatenate(C4," ",D4)



"Steelsilk" wrote in message
...
I have looked this up in the help section. The instructions and the example
are not the same. I have tried several variations of both but I'm still
not
getting the results. Any help is greatly appreciated. I have included some
of
the formulas that I've tried.

=(C4&" "&D4) from the instructions
=C4&" "&D4 from the example
=(C4,&" "&D4)
=(C4&"&D4)