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.
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 ', ,'.
Practise TEXTJOIN
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All TEXTJOIN practice exercises →