Functions
TEXTJOIN
Join values with delimiter, optionally skip empty
Try it
When to use it
When should I use TEXTJOIN instead of the & operator?
Use TEXTJOIN when you are joining many values with the same separator and want to skip blanks automatically; use & for quick one-off concatenations.
How do I make TEXTJOIN skip empty values?
Set the second argument (ignore_empty) to TRUE and blank cells are left out, so you do not get doubled-up separators.
Use cases
Build a full name from parts
Combine tags while skipping blanks
Used in
operations · sales · retail
Syntax
TEXTJOIN(delimiter, ignore_empty, value1, ...)