Combining data from multiple cells into one cell.

S

Steelsilk

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

Teethless mama

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?
 
G

Gord Dibben

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
 
Top