Getting a space between Concatenated cells

K

Kristine

HI,

When merging data from multiple cells to one cell, is there a way to make a space between the merged text? Example, to have the end cell look like "Bob Jones" instead of "BobJones"?

Thanks to anyone who can help!
 
P

Peo Sjoblom

=A1&" "&B1

--

Regards,

Peo Sjoblom

Kristine said:
HI,

When merging data from multiple cells to one cell, is there a way to make
Click to expand...
a space between the merged text? Example, to have the end cell look like
"Bob Jones" instead of "BobJones"?
 
Top