Merge Cells for Microsoft Excel

Merge cells in Excel 2013, 2010-2003, combine columns and rows

With Merge Cells you can efficiently merge the contents of several Excel cells into one without losing data.

  • Combine multiple cells into one cell
  • Merge columns row by row
  • Combine rows column by column
  • Use any separator to join the content of cells (comma, line-break, space, etc.)
  • Keep all data if there are multiple values and never see "The selection contains multiple data values" message

Complete support for:

Merge cells in Excel 2010, 2007, 2003, and 2013

See also: Merge data from 2 Excel tables in 5 easy steps

If you need to compare two Excel tables by key columns and merge matching data,
please use Merge Excel Tables wizard.

Merge cells in Excel exactly as you need them

This smart plug-in will save hours of your time. A couple of clicks and you have data from several Excel cells combined into one cell, or entire Excel rows and columns merged exactly as you need them. The Merge Cells joins various types of data such as names, numbers, dates, special symbols or text. You can separate the merged cells with any character, including the line break or carriage return.

Combine Excel columns row by row using any separator and place the results to the left cell of each row or the right cell of each row. More about combining columns in Excel.

Combine Excel columns

Join data from several rows column-by-column and place the results to the top or bottom cell of each column. More about merging Excel rows.

Join data from several rows column-by-column

Merge multiple cells into one cell and place the results to top left / right corner of the selected range or bottom left / right corner of the selected range. More about merging multiple cells to one.

Merge multiple cells into one cell

Keep all data if the selection contains multiple values

One more fascinating feature of the Merge Cells is that it keeps all data when the selection contains multiple data values. If you try to merge data from multiple cells into one cell using the standard Microsoft Excel option, you will get the following error message: "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."

With Merge Cells you will never see this message again. The add-in preserves all data if the selection contains multiple data values. Your data in Microsoft Excel will never be lost!

How to merge two columns in Excel

Imagine that you have a list of your clients' addresses split into three columns: Address, City and ZIP code. You want to have the clients' addresses in one cell separated with a comma and a line break.

  1. In your worksheet, select the text cells you want to combine and click the Merge Cells icon.
  2. In the Merge Cells dialog box, set the parameters as follows:
    • "Merge selected cells" field: row by row.
    • "Separate values with" field: select "Other" option, then enter a comma and press Alt+Enter in the edit box.
    • "Place the results to" field: select left cell.
    • Check the "Clear the content of selected cells" checkbox.
    • Check the "Skip empty cells" checkbox.
    • Check the "Wrap text" checkbox.
    • Click the Merge button.
  3. That's all, now you have the addresses in one cell separated with comma and line break.

Select the additional options for merging cells

  • Merge multiple ranges (even non-adjacent ones) and place the results into the selected cell
  • Clear the cells after their content has been merged
  • Combine all areas in the selection
  • Exclude empty cells from merging
  • Wrap text in the resulting cells
29.95
Buy now

Combine values in Excel with Merge Cells

You can view the video in the fullscreen mode by clicking fullscreen icon

Merge Cells screenshots

Combine cells by row, column or all into one, and choose where to place the results

Configure the settings in the Merge Cells Wizard dialog box

Merge multiple Excel cells by selecting them and clicking the icon

Select the cells you want to merge and click the Merge Cells Wizard icon

Pick the settings: choose the delimiter you want and have a backup copy of your table

Pick the settings: choose the delimiter you want and have a backup copy of your table

Your Excel data merged by row

Your Excel data merged by row

Free Download
Free 15-day trial version, 2/28/2014

Merge Cells for Excel system requirements:

Operating System

  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Vista (32- and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 2.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Microsoft Excel

  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Merge Cells version

Current add-in version: 4.3.6
published on: Feb 28, 2014

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.