Table of Contents

Merge Cells

Merge cells into one large cell to make clear that a label in Excel applies to multiple columns. Use CONCATENATE TEXTJOIN or Flash Fill to merge cells without losing data.

1. We start simple. Enter a label in cell A1.

Enter a Label in Excel

2. Select the range A1:G1.

Select the Range

3. On the Home tab in the Alignment group click Merge & Center.

Click Merge & Center

Result:

Merged Cells in Excel

This feature only keeps the value in the upper-left cell and deletes all other values!

4. For example enter a label in cell A1 B1 and C1 and select these cells.

Select Multiple Cells

5. On the Home tab in the Alignment group click Merge & Center.

Click Merge & Center

Result:

Excel Deletes All Other Values

Note: click Merge & Center again to unmerge cells (cell B1 and C1 will be empty). Press Ctrl + z to undo this action.

6. Use the CONCATENATE function in Excel to merge cells without losing data.

CONCATENATE function

Explanation: this function concatenates (joins) the string in cell A1 a space and the string in cell B1.

7. If you’re using Excel 2016 or later use TEXTJOIN to merge cells. This function ignores empty cells (if the second argument is set to TRUE).

TEXTJOIN function

We saved the best for last. You can also use Flash Fill to merge cells.

8. For example select cell C2 below. Type the company name and the product type. We used a colon (:) and a space but you can use any delimiter.

Merge Cells

9. On the Data tab in the Data Tools group click Flash Fill (or press CTRL + E).

Click Flash Fill

Result:

Use Flash Fill to Merge Cells

Wow! Visit our page about concatenation or flash fill for more information and examples.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog