& : using this connector to combine cells and commas. Press Enter key, then the cells are combined with comma separated. Generic formula: text_1&','&text_2&','&…&',' &text_nĪrguments Text_1, text_2, text_n: the cells or text strings you want to combine with comma.įor instance, you want to combine the cells of each row across column B, column C, column D and column E into one cell with commas, please use below formula in a blank cell. Here this tutorial provides some formulas to join multiple cells into one cell with comma as separator as below screenshot shown, and also explains how the formulas work in Excel.įormula 1 Combine cells with comma by using & Combine Duplicate Rows And Sum The Values In Excel. Users have to use another method to merge multiple rows of data into one row without deleting data. Excel only keeps the data in the upper-left most cell, if you apply 'Merge & Center' command (Home tab Merge & Center on the Alignment panel) to merge rows of data in Excel. This will open the Merge Cells dialog box with the preselected settings that work fine in. Go to the Ablebits Data tab Merge group, click the Merge Cells arrow, and then click Merge Rows into One. Select the range of cells where you want to merge rows. Combine rows in Excel with Merge Cells add-in. Select one cell which you will place the result, type this formula =A1&' ' &B1, A1 and B1 are the cells you want to join together, “ “ is the separator between two cell contents, press Enter key, and drag fill handle down to apply the formula to cells. Here we have one formula that can quickly merge two cells into one but keep both contents. But sometimes you may want to combine cells from two different columns into a single column – for example, you have the First Name and Last Name columns and you want to merge them into a single Name. When you work with Excel, you probably have to deal with data separated into multiple rows. In the Combine Columns & Rows dialog box, specify the options as below screenshot shown: (1) Select Combine rows under To combine selected cells. Select the range that you want to merge, and click Kutools Combine. Merge rows of data into one row with Kutools for Excel.

How To Combine Data In 2 Cells In Excel.

Kutools excel merge cells