BeginnerText Functions
Build a mailing address with TEXTJOIN
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
6 min15 points
TEXTJOIN
Joins text values with a separator, and can skip the empty ones.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, ...)
Text Functions. Available from Excel 2019.
Practise TEXTJOIN2 interactive exercises, free, no account needed
A worked example
=TEXTJOIN(", ",TRUE,B2:E2)
Returns 418 Mill Street, Akron, OH
Joins the address parts, skipping the empty suite field.
Where it goes wrong
Passing FALSE as the second argument keeps empty cells, which produces orphaned separators like ', ,'.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- Joining with & works, but Ridgeway has no suite — you get "418 Mill Street, , Akron, OH" with a double comma. TEXTJOIN can skip the empty ones for you.Build a mailing address with TEXTJOIN
- Joining with ampersands has no way to skip the blank, so you get the stray comma back. TEXTJOIN exists precisely because this pattern breaks on empty fields.Skip blanks when joining an address
Practise TEXTJOIN
Knowing what a function does and being able to write it from memory are different skills. These close the gap.