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

Merge Cells Wizard for Microsoft^® Excel^®

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

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

• 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 join cells in Excel row by row

1. Select the cells with the values you want to join row by row in your Excel worksheet.
   
2. Click the Merge Cells Wizard icon .
3. Click on the down arrow next to the Merge selected cells field and select row by row from the drop-down list.
   
4. If you want to have the merged values separated by a comma, space or any other character, you can choose the separator in the Separate values with section. There is a set of standard separators to choose from; just select the one you need.
   
   If you want to use a different character or a character set, enter it in the Other field. The values you enter in the Other field are saved. Next time you use the add-in, you can see them in the Other drop-down list.
   
5. To select the location for the resulting values, click the arrow next to the Place the results to field. You will see a drop-down list with two options: left cell and right cell.
   
6. Check the Clear the contents of selected cells checkbox to delete the values in the selected cells after merging them.
   
7. If you want to merge the selected cells by row, tick the Merge all areas in the selection checkbox.
   
8. To avoid empty values in the results, exclude empty cells from the merge by checking the Skip empty cells option.
   
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 as is, check the Create a backup copy of the worksheet check box. A new worksheet with a copy of your original data will appear in the workbook after the merge.
    
11. Click the Merge button to merge values from the selected cells.

How to combine the selected cells column by column

1. Select the cells with the values you want to merge column by column in your Excel worksheet.
   
2. Click the Merge Cells Wizard icon.
3. Next to the Merge selected cells field, click on the down arrow and select column by column from the drop-down list.
   
4. If you want to have the merged values separated by a comma, space or any other character, you can choose the separator in the Separate values with section. There is a set of standard separators to choose from; just select the one you need.
   
   If you want to use a different character or a character set, enter it in the Other field. The values you enter in the Other field are saved. Next time you use the add-in, you can see them in the Other drop-down list.
   
5. Select the location for the resulting values in the Place the results to field. It can be the top cell or the bottom cell of each column in the selected range.
   
6. Check the Clear the contents of selected cells checkbox to delete the values in the selected cells after merging them.
   
7. If you want to merge the cells you selected, tick the Merge all areas in the selection checkbox.
   
8. To avoid empty values in the results, exclude empty cells from the merge by checking the Skip empty cells option.
   
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 as is, check the Create a backup copy of the worksheet check box. A new worksheet with a copy of your original data will be created in the workbook after the merge.
    
11. Click the Merge button to merge values in the selected cells.

How to combine multiple cells into one cell

1. In your Excel worksheet, select the cells with the values you want to merge into one cell.
   
2. Click on the Merge Cells Wizard icon.
3. In the Merge selected cells field, select in one cell.
4. If you want to have the merged values separated by a comma, space or any other character, you can choose the separator in the Separate values with section. There is a set of standard separators to choose from; just select the one you need.
   
   If you want to use a different character or a character set, enter it in the Other field. The values you enter in the Other field are saved. Next time you use the add-in, you can see them in the Other drop-down list.
   
5. In the Place the results to field, select the location for the results:
   • The top-left corner
   • The top-right corner
   • The bottom-left corner
   • The bottom-right corner of the selected range
   
6. Check the Clear the contents of selected cells checkbox to delete the values in the selected cells after merging them.
   
7. If you want to merge the cells you have selected, select the Merge all areas in the selection checkbox.
   
8. To avoid empty values in the results, exclude empty cells from the merge by checking the Skip empty cells option.
   
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 as is, check the Create a backup copy of the worksheet check box. A new worksheet with a copy of your original data will appear in the workbook after the merge.
    
11. Click the Merge button to merge cells values.

Back to Merge Cells Wizard homepage

Download now and see how it can help you