TEXTJOIN
Join text from multiple cells with a separator, skipping blanks.
TEXTJOIN combines values with a delimiter and can ignore empty cells — cleaner than chaining & or CONCATENATE.
Excel
=TEXTJOIN(" ", TRUE, A2, B2)Google Sheets
=TEXTJOIN(" ", TRUE, A2, B2)How it works
- 1" " is the separator between values.
- 2TRUE skips empty cells.
- 3A2, B2 are the values to join.