How To Combine Two Columns In Excel?

Use the ampersand formula: `=A1&B1`

Add a separator if needed: `=A1&” “&B1`

Use `=CONCAT(A1,B1)`

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

Enter the formula in a new column

Fill down to combine the rest of the rows

Copy the results and paste as values if you want to keep only the combined text

Suggested for You

Trending Today