Merge Cells Wizard for Excel 2.2.1.58

Merge Cells Wizard for Excel 2.2.1.58 is an add-in for Microsoft Excel able to quicky combine values from several cells into one; and merge entire rows, columns, or a range of cells in Microsoft Excel sheets retaining their values.

This small plug-in will save hours of your time. A couple of clicks and you have joined data from several Microsoft Excel cells into one cell, or combined whole Microsoft Excel rows and columns. Data type does not matter. It could be numbers, dates, special symbols or text data. You can separate the merged values with any character you like (including the carriage return / line break).

Preserve all data if the selection contains multiple values

• One more fascinating feature of the Merge Cells Wizard is that it retains all data if the selection contains multiple data values. If you try to merge data from several cells into one cell in Microsoft Excel, you will get the error message: "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."
• With the Merge Cells Wizard you will not see this message anymore. The Merge Cells Wizard preserves all data if the selection contains multiple data values. Your data in Microsoft Excel will never be lost!

Major Features:

1. Join Microsoft Excel cells row by row using any separator and place the results to:
   • The left cell of each row of the selected range
   • The right cell of each row
2. Merge multiple cells to one cell using any separator and place the results to:
   • The top left corner of the selected range
   • The top right corner
   • The bottom left corner
   • The bottom right corner
3. Combine the selected Microsoft Excel cells column by column and place the results to:
   • The top cell of each column of the selected range
   • The bottom cell of each column
4. Merge multiple ranges (even non adjacent) and place the results to the selected cell.
5. Clear the cells the data from which have been joined.
6. Combine all areas in the selection.
7. Exclude empty cells from merging.
   

Requirements: Microsoft Excel 2007, 2003, XP (2002), 2000

WareSeeker Editor