Use the ampersand formula: `=A1&B1`
Add a separator if needed: `=A1&” “&B1`
Use `=CONCAT(A1,B1)`
Use `=TEXTJOIN(” “,TRUE,A1,B1)`
Enter the formula in a new column
Fill down to combine the rest of the rows
Copy the results and paste as values if you want to keep only the combined text
