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"?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Function 3
Trailing Spaces in Merged Cells 1
Conditional Concatenate? 2
Allow spaces between lines of text within cell 1
How to merge cells vertically - and keep all data 0
Merging cells and keeping their contents 2
Inserting space between merged text 3
merging 2 cells and adding a space. 1

Back
Top