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)