How to Merge Two Columns Without Losing Data in Excel

Since you’re here, you’ve must tried to merge and center two cells to get them combined, but to your surprise, you only got the data in the left cell and right cell data is gone. Even it displayed a warning before merging them, right? To combine two cells we use merge and center but it is used for formatting purposes, hence you only get data in left-upper cell. Its can’t be used to combine data.

Ok. Then question arises how do we combine two columns in excel without loosing any data. It can be done. Let’s just see how.

How to Combine Two Columns in Excel Using Formulas

We all know about the CONCATENATE function of excel. It is used to concatenate two or more strings together. These strings can be in cells. So let’s see an example.

Combine Two Columns In Excel Excel

For this example, we have this sample data. See below image. We need to combine column A and Column B into one to get full name.
1
To combine First Name and Last Name we will use a helping column. Lets name it Full Name in column C.

Now in C2 write this CONCATENATE formula and drag it down.

=CONCATENATE(A2,” “, B2)

2
CONCATENATE Function in excel combines given arguments into one. Here we are adding first name and last name with an space (“ “) in between them.

Now if you don’t want first name and last name column in sheet then first value paste Full Name Column.

  • Select all cell in C column. You can use excel shortcut CTRL+SHIFT+down arrow, if you are in cell C2.
  • Copy it using CTRL+C
  • Now right click on cell C2 and click on Paste Special or press ALT>E>S>V sequentially.
  • 3

  • Select value and OK
  • Select Column A and B and delete them.

And its done.
4
So yeah its done. You have merged two columns without loosing any data, successfully.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube