Excel - combine cells, text data, columns and rows in Excel worksheets

Combining Excel cells, columns and rows and preserve all values - Merge Cell Wizard

Merge Cells Wizard for Microsoft® Excel®

For Microsoft Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

• Introduction
• How to join cells in Excel row by row
• How to combine the selected cells column by column
• How to combine multiple cells into one cell

Back to Merge Cells Wizard homepage

Introduction

Merge Cells Wizard is an add-in for Microsoft Excel that joins cells values. The Merge Cells Wizard can be used each time you need to combine text values from several cells to one cell, or when you need to join several cells preserving the values of these cells.

How to merge cells in Excel row by row

1. In your Excel worksheet, select the cells the values from which you want to join.
2. Click the Merge Cells Wizard button .
3. In the "Merge selected cells" field, select "row by row".
   
4. If you want to separate values, select the separator you like from the list in the "Separate values with" section or enter the one you need  in the "Other" field.
5. In the "Place the results to" field, select the location for the resulted values:
   • The left cell of each row of the selected range
   • The right cell of each row
6. If you want to clear the cells of the values that have been joined, check the "Clear the content of selected cells" checkbox.
7. If you want to merge cells you have selected, select the "Merge all areas in the selection" checkbox.
8. If you want to exclude empty cells from merging, check the "Skip empty cells" checkbox.
9. If you want to wrap the text in the cell with the results, check the "Wrap text" check box.
10. If you want to keep a copy of the existing worksheet, check the "Create a backup copy of the worksheet" check box.
11. Click the "Merge" button to merge cells values and close the dialog box.

How to merge the selected cells column by column

1. In your Excel worksheet, select the cells the values from which you want to join.
2. Click the Merge Cells Wizard button .
3. In the "Merge selected cells" field, select "column by column".
   
4. If you want to separate values, select the separator you like from the list in the "Separate values with" section or enter the one you need  in the "Other" field.
5. In the "Place the results to" field, select the location for the resulted values:
   • The top cell of each column of the selected range
   • The bottom cell of each column
6. If you want to clear the cells of the values that have been joined, check the "Clear the content of selected cells" checkbox.
7. If you want to merge cells you have selected, select the "Merge all areas in the selection" checkbox.
8. If you want to exclude empty cells from merging, check the "Skip empty cells" checkbox.
9. If you want to wrap the text in the cell with the results, check the "Wrap text" check box.
10. If you want to keep a copy of the existing worksheet, check the "Create a backup copy of the worksheet" check box.
11. Click the "Merge" button to merge cells values and close the dialog box.

How to merge multiple cells into one cell

1. In your Excel worksheet, select the cells the values from which you want to join.
2. Click the Merge Cells Wizard button .
3. In the "Merge selected cells" field, select "in one cell".
   
4. If you want to separate values, select the separator you like from the list in the "Separate values with" section or enter the one you need  in the "Other" field.
5. In the "Place the results to" field, select the location for the resulted values:
   • The top left corner of the selected range
   • The top right corner
   • The bottom left corner
   • The bottom right corner
6. If you want to clear the cells of the values that have been joined, check the "Clear the content of selected cells" checkbox.
7. If you want to merge cells you have selected, select the "Merge all areas in the selection" checkbox.
8. If you want to exclude empty cells from merging, check the "Skip empty cells" checkbox.
9. If you want to wrap the text in the cell with the results, check the "Wrap text" check box.
10. If you want to keep a copy of the existing worksheet, check the "Create a backup copy of the worksheet" check box.
11. Click the "Merge" button to merge cells values and close the dialog box.

Back to Merge Cells Wizard homepage

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.