How To Combine To Columns In Excel?

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

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

Use a comma and space: `=A1&”, “&B1`

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

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

Fill the formula down for the rest of the rows

Copy the combined results

Paste Special > Values if you want to keep only the combined text

Suggested for You

Trending Today