Merge multiple Excel cells into one

Before you start

• A special Back up this worksheet option will create a safe copy of your original sheet.
• If several non-adjacent ranges are selected, the tool merges cells within each range individually.

Merging options

After you select the range, you'll have to pick one of the merging options for the cells. Please see below the examples of how each of them works.

• Columns into one
  
• Rows into one
  
• Cells into one
  

Start Merge Cells

Run the add-in by clicking on its icon in the Merge group on the Ablebits Data tab:

How to combine Excel cells, columns, and rows

The add-in's window lets you adjust the following options:

1. Select the range in your worksheet or use the Expand selection or Select range icons on the right.
2. In this dropdown, choose the merging option: Columns into one, Rows into one, Cells into one.
3. Combine with offers a set of standard delimiters to use between the merged values: semicolon, comma, period, space, line break. Also, you can scroll down to select an aggregate function, please see more details in the Combine cells with aggregate Excel functions section.
   Tip. You can enter any combination of characters into the field or leave it blank to stitch the values together. The separators you enter manually are saved in the drop-down list for the next time you use the add-in.
4. Choose destination for the result in the Place the results to drop-down list: left or right column; top or bottom row; top-left, top-right, bottom-left, or bottom-right cell.
5. Use the additional options to adapt the results to your table:
   • Check the Clear the contents of the selected cells checkbox to delete the source values after merging them.
   • If you want to combine the selected cells, and not only their values, choose to Merge all areas in the selection.
   • Avoid getting extra separators when merging values by checking off Skip empty cells.
   • Select the Wrap text option to make the joined values visible in your worksheet.
6. We recommend selecting Back up this worksheet to get a copy of your current table as is.

Click the Merge button to combine values from the selected columns in Excel.

Combine cells with aggregate Excel functions

If you've got numerical data, you can not only combine values but also apply aggregate Excel functions. For this, select the function of interest in the Combine with drop-down list: