Merge cells in 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, cells values. Use the Merge Cells Wizard every time you need to combine data from several cells into one cell or when you need to merge cells in Microsoft Excel sheets retaining their values. With Merge Cells Wizard you can join data from several Microsoft Excel cells into one cell using any separator you like (including the carriage return / line break) as well as easily combine Microsoft Excel rows, columns and text data.

Preserve 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

• OS: Microsoft Windows Vista, Microsoft Windows 2003, Windows XP, 2000, ME, 98
• 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.