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
