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
Combine first and last name
Join name parts with a space.
=TEXTJOIN(" ",TRUE,A2,B2)Ignores blank middle names if included.
Create a comma list
Combine selected tags.
=TEXTJOIN(", ",TRUE,C2:F2)Useful for categories or attributes.
Join visible helper values
Combine non-empty notes.
=TEXTJOIN("; ",TRUE,Notes[Comment])Makes a readable summary.
Build an address line
Join address fields while skipping blanks.
=TEXTJOIN(", ",TRUE,A2:D2)Cleaner than many IF checks.
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.
Here are some ideas for you
Optional resources that may help if you are learning formulas, building reports, or working in spreadsheets often.
- Excel formula booksSee ideas
Practice formulas with structured examples you can keep beside your desk.
- Excel shortcut guidesSee ideas
Build speed with keyboard shortcuts for selection, formatting and navigation.
- Numeric keypadsSee ideas
Helpful if you enter many numbers on a laptop or compact keyboard.
- External monitorsSee ideas
Useful for viewing large worksheets, formulas and reference tables side by side.
- Desk notebooksSee ideas
Sketch formula logic, report ideas and table structures before building.
- Laptop standsSee ideas
Make long spreadsheet sessions more comfortable and ergonomic.
Some links in this section may be affiliate links. Choose only what is useful for your own work.