Combining data from multiple cells into one cell.
 

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)

Combining data from multiple cells into one cell.
 

=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)

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)

Combining data from multiple cells into one cell.
 

The one from the instructions and from the example should work for you. What
do you get when you enter those formulas? an error message?


"Steelsilk" wrote:

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)

Combining data from multiple cells into one cell.
 

What results do you want?

Either 1 and 2 formulas will do the trick.

C4 contains qwerty
D4 contains asdfgh

=C4&" "&D4 returns qwerty asdfgh


Gord Dibben MS Excel MVP

On Thu, 17 May 2007 05:31:03 -0700, Steelsilk
wrote:

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)