Merge cells in Microsoft Excel - Combine columns, rows in Excel workbooks

Merge Cells Wizard for Microsoft^® Excel^®

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

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

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

This smart plug-in will save hours of your time. A couple of clicks and you have data from several Excel cells joined into one cell, or entire Excel rows and columns merged exactly as you need them. The Merge Cells Wizard combines various types of data such as numbers, dates, special symbols or text. You can separate the merged values with any character, including the line break / carriage return.

Keep all data if the selection contains multiple values

One more fascinating feature of the Merge Cells Wizard is that it keeps all data when the selection contains multiple data values. If you try to merge data from several cells into one cell using the 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 Merge Cells Wizard you will never see this message again. The Merge Cells Wizard add-in 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 that you have a list of your clients' addresses split into three columns: Address, City and ZIP code. You want to have the clients' addresses in one cell separated with a comma and a line break.

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, set the parameters as follows:

• "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.
• Check the "Clear the content of selected cells" checkbox.
• Check the "Skip empty cells" checkbox.
• Check the "Wrap text" checkbox.
• Click the "Merge" button.

3. That's all, now you have the addresses in one cell separated with a comma and a line break.

With Merge Cells Wizard for Microsoft Excel you can:

• Join Microsoft Excel cells row by row using any separator and place the results to:
  • Left cell of each row
  • Right cell of each row
  More about merging cells row by row
  
  
• Merge multiple cells into one cell using any separator and place the results to:
  • Top left / right corner of the selected range
  • Bottom left / right corner of the selected range
  More about joining multiple cells to one cell
  
  
• Combine selected Microsoft Excel cells column by column and place the results to:
  • Top cell of each column
  • Bottom cell of each column
  More about combining cells column by column
  
  
• Merge multiple ranges (even non-adjacent ones) and place the results into the selected cell.
• Clear the cells after their content has been merged.
• Combine all areas in the selection.
• Exclude empty cells from merging.
• Wrap text in the resulting cells.

Download now and see how it can help you