Ukraine flag War in Ukraine. Here's what Ablebits is doing to make sure our team and projects are safe.

Merge Cells in Excel

With Text Toolkit for Microsoft Excel

If you would like to join or summarize cell values when merging cells, use the Merge Cells tool available in Text Toolkit for Excel.

To start working with Merge Cells, open your Excel and click the Text Toolkit icon on the ribbon:
This is the Text Toolkit icon.
The add-in pane will appear. Find and click Merge Cells there:
Start Merge Cells.
Select a range with the cells to be merged and choose options that suit your task:
This is the Merge Cells pane.

  1. This field shows what range is going to be processed.
  2. The How to merge drop-down menu contains three lines: Columns into one, Rows into one, Cells into one:
    Pick any of the three options.
    Decide which option corresponds to the desired result and select it from the list.
  3. For the values to be merged, you can use either a delimiter or a function.

    The drop-down list under Combine with offers the following preset delimiters: a space, a comma, a semicolon, a period, and a line break:
    Choose any preset delimiter you like.
    If you need another delimiter, just type it into the Combine with field.

    The delimiters you've used are shown under History:

    The functions to choose between are as follows: AVERAGE, COUNT, COUNTA, MAX, MIN, and SUM.
    Select a function from the list.

  4. The drop-down list under Place the results to changes according to the option selected under How to merge.

    If you merge columns into one, you can pick either the left or right column as a destination for the values to be merged:
    Select a column for the resulting values.
    If you merge rows into one, you can choose between the top row and the bottom one:
    Select a row for the resulting values.
    When you merge cells into one, there are four options available:
    Select a cell for the resulting values.

  5. With a check mark next to Clear the contents of the selected cells, only the resulting values will be shown. The original data will disappear from the processed cells.
  6. If you select the Merge all areas in the selection option, not only values but also cells themselves will be merged.
  7. Check Skip empty cells to make the tool ignore cells that contain nothing.
  8. Pick Wrap text to get a result string displayed line by line in a cell.
  9. With the Create a backup copy option selected, the Restore button is added and a hidden copy of your sheet will be saved. After the tool has processed your data, the Restore button gets enabled. You can click it and return to the previous version of the processed sheet if necessary.
    Here's the Restore button.

    Tip. To see available backup copies, right-click any sheet tab in your Excel workbook and choose "Unhide".

    Unhide any of the backup sheets that you can see in the list.

    Note. You can delete hidden backups with the Remove all backup sheets option in the More menu. To see it, click the three dots in the lower-right corner of the Text Toolkit pane:

    Find the Remove all backup sheets option in the More menu.

When you're done with the settings, click the Merge button.