Excel FunctionsLesson 114Free preview
TEXTJOIN
This lesson is part of Excel · All levels
Summary
TEXTJOIN is an Excel text function that combines many values with a particular delimiter. The syntax is. The ignore_empty argument determines whether a blank cell is passed so that no double separation occurs.
Key points
- Syntax: TEXTJOIN(delimiter, ignore_empty, text1, ...)
- Ignore_empty makes the empty cell not leave a delimiter
- Accept up to 252 text arguments, including cell ranges
- More practical than CONCATENATE for many cells
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.