Addin for Excel to merge cells, columns, rows

Merge Cells Wizard for Excel in detail

Merge Cells Wizard is an add-in that merges Excel cells values. Use Merge Cells Wizard 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.

Have you ever come across such Microsoft Excel-like message when joining several cells with values?

If the selection contains multiple data values, Merge Cells Wizard will help you to avoid loosing data.

With Merge Cells Wizard for Excel you can

• 

  Merge Excel cells into one cell

  
  
  Merge the selected cells in one cell using some separator and place the results to:
  • The top left corner of the selected range;
  • The top right corner of the selected range;
  • The bottom left corner of the selected range;
  • The bottom right corner of the selected range.


• 

  Merge Excel cells row by row

  
  
  Join worksheets cells row by row using some separator and place the results to:
  • The left cell of each row of the selected range;
  • The right cell of each row of the selected range.


• 

  Join cells column by column

  
  
  Join Excel cells column by column using some separator and place the results to:
  • The top cell of each column of the selected range;
  • The bottom cell of each column of the selected range;


• Clear the cells the values from which have been joined;
• Merge all areas in the selection.

Merging Excel cells with Merge Cells Wizard

1. In your Excel worksheet select the cells the values from which you want to join and click the Merge Cells Wizard button.
2. In the Merge Cells Wizard dialog box select (see screenshots above)
   1. how you are going to join cells values,
   2. what separator you want to use,
   3. where you want to place the results.
3. Click the Join button.

If you want to clear the cells the values from which have been joined, select the "Clear the joined cells" check box on the "Options" pane of the Merge Cells Wizard dialog box.

If you want to merge all areas in the selection, select the corresponding check box on the "Options" pane of the Merge Cells Wizard dialog box.

Merge Cells Wizard for Excel works with

• OS: Microsoft Windows® Vista , Windows 2003, Windows XP, 2000, ME, 98
• Microsoft Excel 2007, Excel 2003, Excel XP, 2002, and Excel 2000.

See also in "Excel - Merging cells, columns, rows, etc."

• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..