Merge data from different cells

J

Jenny

Is there an easy way to merge information that is currently in different
cells so that it's combined all into one cell?
 
J

JS

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.
 
J

Jenny

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...
 
Top