Excel

How to Merge Two Columns in Excel

How to Merge Two Columns in Excel

There are a few ways to merge two columns in Excel. One way is to use the concatenate function. To do this, highlight the cells you want to merge, and then go to the Formulas tab and select the concatenate function. In the function box, type in the cell references of the first and second column, and then click the concatenate button. This will merge the two columns into one.

Another way to merge two columns is to use the text to columns function. To do this, highlight the cells you want to merge, and then go to the Data tab and select the text to columns function. In the function box, select the delimiter you want to use to separate the two columns, and then click the text to columns button. This will merge the two columns into one, and will also split the text into two columns based on the delimiter you selected.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.