Merge Cells Wizard for Microsoft Excel

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 Wizard 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 Wizard 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 Wizard 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 Wizard icon.
2. In the Merge Cells Wizard 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 Wizard

You can view the video in the fullscreen mode by clicking

Merge Cells Wizard 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 Wizard 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 Wizard 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, 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 Wizard version

Current add-in version: 4.0
published on: Jan 15, 2013

This add-in comes as part of Ultimate Suite (20+ useful Excel tools)

Try Merge Cells Wizard for Excel in the package without any limitations for 30 days.
You can order the add-in separately or buy it in the Suite at the best price.

$ 29.95

Buy now