Use the ampersand operator: `=A1&B1`
Add a space between cells: `=A1&” “&B1`
Add any separator you want: `=A1&”, “&B1`
Use the CONCAT function: `=CONCAT(A1,B1)`
Use the TEXTJOIN function with a delimiter: `=TEXTJOIN(” “,TRUE,A1,B1)`
Use the CONCATENATE function: `=CONCATENATE(A1,B1)`
Copy the formula down to combine other rows
