Getting a space between Concatenated cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=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"?
 
Back
Top