How to merge and combine column data in Microsoft Excel 2016 ?

This blog post will provide insights on how you can merge and combine column values in Microsoft Excel 2016.

How to merge and combine column data in Microsoft Excel 2016 ?

You can use to merge and combine column data without losing data in Excel using the & operator to concatenate data.

Assume that you have the column A and B and you wish to merge and combine the column data and display it in Column C.

You can simply add the formula as shown to the cells of Column C

=A1&” “&B1

This will merge and combine the column data and display it in with spaces in between.

image

Leave a Reply