How To Combine 2 Cells In Excel?

Select the cell where you want the combined result to appear

Type `=A1&B1` to combine two cells without a space

Type `=A1&” “&B1` to combine two cells with a space

Press Enter

Copy the formula down if needed

Use `=CONCAT(A1,B1)` to combine cells in newer Excel versions

Use `=TEXTJOIN(” “,TRUE,A1,B1)` to combine cells with a delimiter

If you want to keep only the combined text, copy the result and paste as values

Suggested for You

Trending Today