ExcelBanter - Merge data from different cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Merge data from different cells (https://www.excelbanter.com/excel-discussion-misc-queries/20240-merge-data-different-cells.html)

Jenny

Merge data from different cells

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.

"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?

Jenny

Sounds perfect - thanks

"JS" wrote:

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?

All times are GMT +1. The time now is 03:52 PM.