Excel Tool

Order Online
Our company contact information There you can find frequently asked questions and answers

Home | Products |Purchase | FAQ | Contact Us | Useful Resources

Merge columns in Excel (Combine)

If you have a customer information where each column contains certain details such as the first name, last name.
What we want is to merge the two columns to one. so that the result would look similar to this:


Tool location: Add-Ins →Excel Tool Box → Merge Columns: Shortcuts: (Alt + X + X + G )

The sample table: merge columns.xlsx

Select the cells with the values you want to merge column by column in your Excel worksheet.

Open the Merge Columns pane by clicking on: Add-Ins →Excel Tool Box → Merge Columns or pressing the Shortcuts: (Alt + X + X + G ).

Add the first column: First Name

Click the Add Column > button: Add the columns that you want to merge:

In between columns to enter additional characters: ', ' ( Commas and Spaces, Can also enter other characters you want), then Click the Add Text > button.

Add The second column: Last Name

Click on the down arrow and select column 'Last Name' from the drop-down list, then Click the Add Column > button.

 

Click the OK button:

Results:

Copyright © 2001-2014 Excel-Tool All Rights Reserved.

Copyright Excel-Tool All rights reserved