How To Combine 2 Columns In Excel?

Use the formula `=A1&B1`

Use the formula `=CONCAT(A1,B1)`

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

Add a separator with `=A1&” “&B1`

Add a comma with `=A1&”, “&B1`

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

Copy the combined column

Paste Special as Values to keep only the results

Suggested for You

Trending Today