Use `=CONCATENATE(text1, text2, …)` to join text values
Use `=CONCAT(text1, text2, …)` as a newer alternative
Use `=TEXTJOIN(delimiter, ignore_empty, text1, text2, …)` to join with a separator
Use `&` to combine cells, such as `=A1&B1`
Add spaces with quotes, such as `=A1&” “&B1`
Add commas or other separators with quotes, such as `=A1&”, “&B1`
Combine numbers and text by wrapping numbers with `TEXT()`
Use cell references instead of typing values directly
Copy the formula down to apply it to multiple rows
Use `TRIM()` to remove extra spaces after concatenation
Use `CHAR(10)` to insert line breaks in concatenated text
Turn on Wrap Text to display line breaks properly
Use absolute references with `$` when needed
Use `TEXTJOIN` to ignore blank cells automatically
Use `CONCAT` or `&` instead of `CONCATENATE` for newer workbooks