How To Combine Cells In Excel?

Select the cells you want to combine.

Go to the Home tab.

In the Alignment group, click Merge & Center.

Choose one option:

Merge & Center

Merge Across

Merge Cells

Unmerge Cells (to reverse)

If you want to combine text without merging cells:

Use CONCAT or CONCATENATE, for example: `=CONCAT(A1,” “,B1)`

Or use `&`, for example: `=A1&” “&B1`

Press Enter.

Suggested for You

Trending Today