Merge cells in Microsoft® Excel® - Combine columns, rows, fields, text and data in Excel workbooks

Merge Cells Wizard for Microsoft® Excel® - merging columns, rows, values, data and text

Merge Cells Wizard for Microsoft® Excel®

For Microsoft Excel 2007, Excel 2003, Excel XP (2002), Excel 2000 .

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!

A couple of clicks and you get the result:

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.