What it does
TEXTJOIN combines text values with a delimiter and can ignore blanks.
Syntax or pattern
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)✅
5 practical examples
1
Combine first and last name
Join name parts with a space.
=TEXTJOIN(" ",TRUE,A2,B2)Ignores blank middle names if included.
2
Create a comma list
Combine selected tags.
=TEXTJOIN(", ",TRUE,C2:F2)Useful for categories or attributes.
3
Join visible helper values
Combine non-empty notes.
=TEXTJOIN("; ",TRUE,Notes[Comment])Makes a readable summary.
4
Build an address line
Join address fields while skipping blanks.
=TEXTJOIN(", ",TRUE,A2:D2)Cleaner than many IF checks.
5
Combine filtered results
Join matching items from FILTER.
=TEXTJOIN(", ",TRUE,FILTER(Products[Name],Products[Category]=H2))Dynamic arrays make TEXTJOIN more powerful.
Common mistakes to avoid
- Not handling missing delimiters.
- Forgetting that some text functions return text, not numbers.
- Using fixed positions when the text layout is not consistent.
Related Excel examples
FAQ
Can text formulas work with Excel Tables?
Yes. Table references can make text-cleaning formulas easier to understand.