Combine Multiple Cells Into One

Merge Cells is an add together-in for Microsoft Excel that combines multiple text cells. Utilise information technology to join values from several cells to one and merge several cells, rows, or columns keeping all data.

Earlier you starting time
Merging options
Start Merge Cells
How to combine Excel cells, columns, and rows
Combine cells with aggregate Excel functions
Related links

Before you starting time

A special Support this worksheet option will create a rubber re-create of your original sheet.
The add together-in brings together all areas in the selection, including non-adjacent ones.

Merging options

Afterwards you select the range, y'all'll have to selection one of the merging options for the cells. Please meet below the examples of how each of them works.

Start Merge Cells

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

How to combine Excel cells, columns, and rows

The add-in's window lets you adjust the following options:
Fine-tune the options to merge data as needed.

Select the range in your worksheet or apply the Expand option or Select range icons on the right.
In this dropdown, choose the merging option: Columns into i, Rows into one, Cells into ane.
Combine with offers a set of standard delimiters to use between the merged values: semicolon, comma, menstruation, space, line break. Also, you can coil down to select an aggregate office, please see more details in the Combine cells with amass 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-downward listing for the next fourth dimension y'all use the add together-in.
Choose destination for the result in the Place the results to drop-down listing: left or right column; top or lesser row; top-left, top-correct, lesser-left, or bottom-right prison cell.
Apply the additional options to adapt the results to your tabular array:
- Check the Articulate the contents of the selected cells checkbox to delete the source values subsequently merging them.
- If you desire to combine the selected cells, and non just 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 brand the joined values visible in your worksheet.
We recommend selecting Back up this worksheet to get a copy of your electric current table equally is.

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

Combine cells with aggregate Excel functions

If yous've got numerical information, 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 listing:

Fine-tune the options to merge data as needed.

Note. For the calculations, the tool uses the standard Excel functions (AVERAGE, COUNT, COUNTA, MAX, MIN, SUM), so if yous face certain difficulties, delight consult a respective section here.