TEXTJOIN
Combines the text from multiple ranges and/or strings.
TextModern Excel FunctionsMost UsedText Cleaning
What it does
Joins text values with a delimiter and can ignore empty cells.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
Arguments
delimiter(text) — Separator to insert between items.ignore_empty(logical) — Whether to ignore empty cells.
Examples
Join non-empty items
Join A2:A5 with ", " ignoring blanks.
FORMULA
=TEXTJOIN(", ",TRUE,A2:A5)RESULT
Apple, Pear, Mango
SAMPLE DATA
| A | |
|---|---|
| 1 | Fruit |
| 2 | Apple |
| 3 | |
| 4 | Pear |
| 5 | Mango |