HomeMicrosoft OfficeExcelHow to merge and combine column data in Microsoft Excel 2016 ?

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021