View Single Post
  #2   Report Post  
JS
 
Posts: n/a
Default

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?