How To Merge 2 Columns In Excel?

Select the cell where you want the merged result to appear

Enter a formula like `=A1&B1`

Add a space between columns if needed: `=A1&” “&B1`

Press Enter

Drag the fill handle down to apply the formula to other rows

Copy the results

Paste Special as Values if you want to keep only the merged text

Use `=CONCAT(A1,B1)` if your Excel version supports it

Use `=TEXTJOIN(” “,TRUE,A1,B1)` if you want to merge with a delimiter and ignore blanks

If you want to physically combine cells, select the cells

Go to Home

Click Merge & Center

Choose Merge Cells or Merge & Center

Suggested for You

Trending Today