How To Merge Two Columns In Excel
Sometimes, we face a situation when we would like to join the data in two columns of a spreadsheet.
For instance, in this file, i would like to join the information in the First name column and the information in the last name column,
and put it in a "Full Name Column".
Is there a simple and easy way to do this without having to manually copy and paste each Name or type them in?
Well it turns out there actually is.
Step 1. Let's insert another column.
Step 2. Right click on the Column "C" letter and choose "insert" from the drop-down menu.
Adjust the column width of the new column.
We want to Join the first name, which appears on row 2.
Step 3. Click on the cell C2.
Step 4. Type in a formula to Join the data in cells A2 and B2.
Step 5. Type Equal to A2 and - that's ampersand, B2.
Step 6. Hit enter.
And we have successfully joined the data in the two cells. But we do have a problem.
We need a space to separate the two names.
Delete the contents of C3. Let's try something a little different.
Step 7. Type equal to.
Which always means we are using a formula.
The A2, ampersand, and now we want a space.
We enclose the literal space within quotes.
So type Double quotes, press spacebar to insert a space, and then Double quotes again.
Ampersand Once more, and then B2.
This inserts a space between the two names.
Step 8. Hit Enter.
Now we have our Two names joined, with a space separating them.
Step 9. To apply the same formula to the rest of the column, simply drag down from the bottom right hand corner of the cell.
So we have now managed to join the data in the two columns into one single column.
Let's call this the FULL NAME column. ...
