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.
"Jenny" wrote:
Is there an easy way to merge information that is currently in different
cells so that it's combined all into one cell?
|