How To Merge Two Cells Data In Excel?

Select the two cells you want to merge

Go to the Home tab

Click Merge & Center

Choose Merge Cells

Keep in mind only the upper-left cell’s data is retained

If you want to combine the text from both cells, use a formula like `=A1&B1`

Press Enter

Copy the formula result

Use Paste Special > Values if needed

Then merge the cells if desired

Suggested for You

Trending Today