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

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.