FormuladrillTEXTJOIN practice
TEXTJOIN joins several texts with a delimiter, optionally skipping empty cells. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
What people get wrong
The ignore_empty argument is what keeps double commas out of a joined list.
Excel exercise that use TEXTJOIN
- Join the tagsLevel 4Pro
Practice TEXTJOIN now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free