Excel Tutorials

If you use Excel a lot, you probably know how to merge cells. However, something you may not use or think much about is merging columns. At some point, you will have a need to merge two or more columns, and you’ll wonder how to do it but figure it’s probably too hard and you find another way to solve your dilema. But, merging columns in Excel is really easy, and in this tutorial, I will show you how to merge columns in a couple of quick steps.

1. First, click on the blank cell where you want to put the new merged data from the different columns. Go to Formulas>Function Library>Insert Function and the “Insert Function” pop up window will appear. Under “Or select a category” select “text” from the drop down menu. And under “Select a function” select “CONCATENATE.” Next, click OK.
2. The “Function Arguments” pop up window box appears. Next, type the cell address of the first column you want to merge (use the first cell of the first column you want to merge) in “Text1” and enter the second column address in “Text2” - again use the first cell address. And click OK.
3. Now you will see the new column with the merged data from different columns created in the location where you had originally specified.

Good Job! So the next time you wonder about merging columns, you’ll remember how easy it really is.

Posted in Columns | Comments (2)