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)