Merging cells in Excel without loosing data Home // Merging cells in Excel without loosing data

Merging cells in Excel without loosing data

It’s easy to highlight a couple of adjacent cells and click on the merge icon to make the two become one.  Using this method, you’ll end up with only the data from one cell.  But, what if you want the CONTENTS of both cells to be merged? (example – a column of last names and a column of first names merged into a single column that shows “last name, first name”)  Here’s how:
  1. Select the cell in which you want to combine the contents of other cells.
  2. To start the formula, type =(
  3. Select the first cell that contains the text that you want to combine, type &” “&(with a space between the quotation marks), andthenselect the next cellthat contains the text that you want to combine.
    To combine the contents of more than two cells, continue selecting cells, making sure to type &” “& between selections. If you don’t want to add a space between combined text, type & instead of &” “&. To insert a comma, type &”, “& (with a comma followed by a space between the quotation marks).
  4. To finalize the formula, type )
  5. To see the results of the formula, press ENTER.

Once you have the first cell combination looking right, you can copy it down the length of the column and, voila! — you’re done.  Don’t forget – if you want to take the resulting column and paste it into another spreadsheet or another column – select what you want –> right click + “copy” –> select the destination –> right click + PASTE SPECIAL and then select “values.”  This will copy/paste the results of your formula instead of copying the formula itself (which would likely generate errors).

It’s easy to highlight a couple of adjacent cells and click on the merge icon to make the two become one.  Using this method, you’ll end up with only the data from one cell.  What if you want the CONTENTS of both cells to also be merged? (example – a column of last names and a column of first names merged into a single column that shows “last name, first name”)  Here’s how:
  1. Select the cell in which you want to combine the contents of other cells.
  2. To start the formula, type =(
  3. Select the first cell that contains the text that you want to combine, type &” “&(with a space between the quotation marks), andthenselect the next cellthat contains the text that you want to combine.
    To combine the contents of more than two cells, continue selecting cells, making sure to type &” “& between selections. If you don’t want to add a space between combined text, type & instead of &” “&. To insert a comma, type &”, “& (with a comma followed by a space between the quotation marks).
  4. To finalize the formula, type )
  5. To see the results of the formula, press ENTER.
Once you have the first cell combination looking right, you can copy it down the length of the column and, voila! — you’re done.  Don’t forget – if you want to take the resulting column and paste it into another spreadsheet or another column – select what you want –> right click + “copy” –> select the destination –> right click + PASTE SPECIAL and then select “values.”  This will copy/paste the results of your formula instead of copying the formula itself (which would likely generate errors).

A compendium of thoughts, reflections, and suggestions regarding life online.

Get Google Apps for Work

Click here to sign up for a no-obligation free trial.

For $5/month per user, you can’t beat the value. And it’s easy to use your own domain, if you have one, for your Google Apps for Work suite, without disrupting your existing website.

Caveat

While we do our best to offer easy-to-follow suggestions on maintaining your website, computer, smartphone, etc., we do not accept any responsibility for any damage or lost data you may encounter. All actions taken as a result of reading this blog are at the users’ own risk. Piedmont Technology strongly suggests that users make and test regular backups!