Merge Cells for Microsoft Excel

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

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.

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.

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.

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:
   • "How to merge" field: row by row.
   • "Separate values with" field: type a comma and press Alt+Enter in the edit box.
   • "Place the results to" field: select left column.
   • Check the "Clear the content of selected cells" checkbox.
   • Pick the "Skip empty cells".
   • 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

Find more details

• Video: combine values in Excel with the Merge Cells add-in
• Download the Merge Cells add-in and try for yourself

Three ways to merge columns in Excel without losing any data

How to merge rows in Excel

Merge Cells screenshots

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

Merge multiple Excel cells by selecting them and clicking the icon

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

Your Excel data merged by row

Merge Cells for Excel system requirements:

Microsoft Excel

• Microsoft Excel 2016 (32- and 64-bit)
• Desktop Excel included in Office 365
• Microsoft Excel 2013 (32- and 64-bit)
• Microsoft Excel 2010 (32- and 64-bit)
• Microsoft Excel 2007
• Microsoft Excel 2003

Operating System

• Windows 10 (32- and 64-bit)
• 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 4.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

Merge Cells version

Current add-in version: 5.0.6
published on: Nov 24, 2015

End-User License Agreement (EULA).