Merge Cells Wizard for Microsoft Excel
Merge cells in Excel 2013, 2010-2003, combine columns and rows
With Merge Cells Wizard you can efficiently merge the contents of several Excel cells into one without losing data.
Complete support for:
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!
Need to merge 2 Excel tables?
If you want to merge data from two Excel spreadsheets, check out Merge Tables Wizard. With this add-in you can instantly join 2 different worksheets.
Need to combine data from duplicate rows?
Combine Rows Wizard perfectly joins all values from duplicate rows into one based on the selected key column or columns. The wizard can merge all entries or pull unique data only, omitting all duplications and empty cells.
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.
- In your worksheet, select the text cells you want to combine and click the Merge Cells Wizard icon.
- 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.
- That's all, now you have the addresses in one cell separated with comma and line break.
Select the additional options for merging cells
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:
- 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 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.
- ABOUT US