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

Combining Excel text cells, data, columns and rows - Merge Cell Wizard

Merge Cells Wizard for Microsoft® Excel®

For Microsoft Excel 2007, Excel 2003, Excel XP (2002), Excel 2000 .

• Introduction
• How to join cells in Excel row by row
• How to combine 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 whose data you want to combine.
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, in the "Separate values with" field, enter a separator you like or select one of the existing separators.
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 the values from which have been joined, check the "Clear the content of selected cells" checkbox.
7. If you want to combine 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. Click the "Merge" button to merge cells values and close the dialog box.

How to merge selected cells column by column

1. In your Excel worksheet, select the cells whose data you want to combine.
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, in the "Separate values with" field, enter a separator you like or select one of the existing separators.
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 the values from which have been joined, check the "Clear the content of selected cells" checkbox.
7. If you want to join the 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. 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, in the "Separate values with" field, enter a separator you like or select one of the existing separators.
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 the values from which have been joined, check the "Clear the content of selected cells" checkbox.
7. If you want to join 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. Click the "Merge" button to combine cells values and close the dialog box.

Back to Merge Cells Wizard homepage