This program is an add-in for Microsoft Excel that joins cells values. Use it each time you need to place values from several cells to one cell or when you need to join several cells preserving the values of these cells.

Merge Cells Wizard is an add-in for Microsoft Excel that merges, or joins, data from multiple cells in a flash. Do you need to combine values from several cells into one? Or, do you want to merge entire rows, columns, or a range of cells in Microsoft Excel sheets retaining their values? If you have the Merge Cells Wizard at hand, it will take you just a few seconds.

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!

With Merge Cells Wizard for Microsoft Excel you can:
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
More about merging cells row by row

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
More about joining multiple cells to one cell

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
More about combining cells column by column

Merge multiple ranges (even non adjacent) and place the results to the selected cell.
Clear the cells the data from which have been joined.
Combine all areas in the selection.
Exclude empty cells from merging.
Merge Cells Wizard for Excel is compatible with
Operating System: Microsoft? Windows Vista? (x32, x64), Microsoft Windows? 2003, Windows XP, 2000.
Microsoft Excel 2007, Microsoft Excel 2003, Microsoft Excel XP, Microsoft Excel 2000.
How to merge columns in Microsoft Excel: 3 easy steps
Imagine, you have list of your clients addresses, and you have three columns with Address, City and ZIP code. You want to combine clients' addresses from multiple cells to one cell separated by line breaks. With Merge Cells Wizard it will take you just one minute.

1.In your worksheet, select the cells you want to combine and click the Merge Cells Wizard icon.

2.In the Merge Cells Wizard dialog box, please set the parameters you need:
"Merge selected cells" field: row by row
"Separate values with" field: press Alt+Enter
"Place the results to" field: select left cell
Check the "Clear the content of selected cells" checkbox
Click the "Merge" button.

3.That's all, you have the addresses in one cell separated by line breaks.

The license of this software is Free Trial Software, the price is $19.95, you can free download and get a free trial.