Use the `&` operator: `=A1&B1`
Use `CONCAT`: `=CONCAT(A1,B1)`
Use `TEXTJOIN` for separators: `=TEXTJOIN(” “,TRUE,A1,B1)`
Use `CONCATENATE`: `=CONCATENATE(A1,B1)`
Add spaces or text inside quotes: `=A1&” “&B1`
Concatenate multiple cells: `=A1&B1&C1`
Combine text and formulas: `=”Total: “&A1`
Fill down the formula to apply it to more rows