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
