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 2010 32-bit, 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 can 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 using 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 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!

How to merge columns in Microsoft Excel: 3 easy steps

Imagine, you have a 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 and separate them 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: select "Other" option, then enter a comma and press Alt+Enter in the edit box.
   • "Place the results to" field: select left cell.
   • Select the "Clear the content of selected cells" checkbox.
   • Select the "Skip empty cells" checkbox.
   • Select the "Wrap text" checkbox.
   • Click the "Merge" button.
   
3. That's all, you have the addresses in one cell separated by line breaks.
   

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 of the range
  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 ones) and place the results to the selected cell.
• Clear the cells of the data that have been merged.
• Combine all areas in the selection.
• Exclude empty cells from merging.
• Wrap text in the cell with the results.

Merge Cells Wizard for Excel is compatible with

• Operating System: Microsoft Windows 7 (x86, x64), Windows Vista (x86, x64), Windows 2003, Windows XP.
• Microsoft Office Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

Try before you buy

Download a fully-functional 15-day evaluation version of Merge Cells Wizard for Excel and try for yourself.