Combine cells, rows, and columns in Excel
Merge Cells Wizard for Microsoft Excel
You have 10 minutes to combine data from several cells into one but when you use the standard Microsoft Excel option, you get the error message: "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."
Merge Cells Wizard for Microsoft Excel presents extended merging functions such as combining values by row, by column or into one cell. Besides, you can pick a separator and some additional options like combining all areas you select or removing values from the chosen cells after merging.
Merge Cells for Excel key features
- Combine Excel data row by row, column by column or into one cell.
- Select a standard separator or enter your own.
- Define where to place the merged results.
- Remove values from the selected cells after merging.
- Merge all areas in the selection.
- Skip empty cells from merging.
- Wrap text in the merged cells.
- Back up the original worksheet.
You can get this add-in as a part of Ultimate Suite for Excel - 20+ add-ins destined to cut your time and clicks on the most frequent spreadsheet tasks.
How Merge Cells Wizard works
Whether you need to combine data in cells, rows, or columns, Merge Cells Wizard for Microsoft Excel is the add-in to help you.
The intuitive wizard displays all available merging options for you. All you need is to select the range or ranges with the values to be combined and the plug-in will neatly join cells, rows, or columns with data.
You can use one of the pre-defined separators or enter your own, clear the cells after merging or join all areas in the selection, skip empty cells, apply text wrapping or automatically save the original copy of your spreadsheet before merging.
Merge data row by row, column by column or into one cell
With Marge Cells Wizard you can combine data exactly as you need it: by row, column or into one cell. Now it takes about 5 clicks to merge parts of names, addresses, or create labels for printing.
Select any separator or enter your own
When you join cells, you can specify the boundary between values by using a separator. It can be one of the common delimiters like line break, comma, space, or semi colon. You can really enter any character or a combination of characters in the Other field.
Define where to place merged results
The enhanced functionality of the add-in enables you to select the destination cell where the results will be moved. While merging rows, you can place them to the left or right cell of each row. When you combine columns, you can choose between placing outcome to the top or the bottom cell of each column. If you join into one cell, it is possible to pick the top left/right or the bottom left/right cell of the range.
Remove values from selected cells after merging
With this merging tool for Excel and its Clear the contents of selected cells option, you can delete values from the cells you pick for the merge.
Merge areas in the selection
If you need to merge all cells in your Excel worksheet by row, column or into one cell, you just tick the Merge all areas in the selection checkbox. It can be useful if you want to avoid empty ranges in your table.
Back up the original worksheet
With this handy tool and the possibility to create a backup copy of the current table, you will regain the original data any time you need them again. This smart feature lets you choose the best merging option without closing the file or losing your data.
Merge Cells Wizard for Microsoft 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 must be installed.
- Microsoft Excel 2013 (32 and 64-bit)
- Microsoft Excel 2010 (32 and 64-bit)
- Microsoft Excel 2007
- Microsoft Excel 2003
Merge Cells Wizard for Excel version
Current add-in version: 4.0
published on: Jan 15, 2013