How To Combine 2 Columns In Excel With A Space?

Use the formula `=A1&” “&B1`

Press Enter

Drag the fill handle down to apply it to other rows

Use `=CONCAT(A1,” “,B1)` if your Excel version supports CONCAT

Use `=TEXTJOIN(” “,TRUE,A1,B1)` if you want to ignore blanks