How to Concatenate Two Columns in Excel?

Use the `&` operator: `=A1&B1`

Add a space between values: `=A1&” “&B1`

Use `CONCAT`: `=CONCAT(A1,B1)`

Use `TEXTJOIN`: `=TEXTJOIN(” “,TRUE,A1,B1)`

Use `CONCATENATE`: `=CONCATENATE(A1,B1)`

Fill the formula down for the remaining rows

Copy the results and paste as values if needed

Suggested for You

Trending Today