Merge data from different cells

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

Guest

Is there an easy way to merge information that is currently in different
cells so that it's combined all into one cell?
 
If in cell A1 you have "Joe" and in cell B1 you have "Smith" if you type in
cell C1 =concatenate(A1,B1) you will get "JoeSmith"; if you want "Joe Smith"
try =concatenate(A1," ",B1)
That should work.
 
Sounds perfect - thanks

JS said:
If in cell A1 you have "Joe" and in cell B1 you have "Smith" if you type in
cell C1 =concatenate(A1,B1) you will get "JoeSmith"; if you want "Joe Smith"
try =concatenate(A1," ",B1)
That should work.
Click to expand...
 
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

Best solution to merge multiple Outlook contacts easily 2
Sharing workbooks limitations - Merged Cells 12
VBA set thick borders around non empty cells in range 0
Conditional Concatenate? 2
Count with merged cells 2
Merge Cell Cut & Paste 1
sorting two columns of merged cells 1
Merging multiple columns into one column (dynamically) 1

Back
Top