Which formula uses TEXTJOIN to combine B2:D2 into a single text string with delimiter '#' and ignores blanks?

Which formula uses TEXTJOIN to combine B2:D2 into a single text string with delimiter '#' and ignores blanks?

• A. =TEXTJOIN("#", TRUE, B2:D2)
• B. =TEXTJOIN("#", FALSE, B2:D2)
• C. =TEXTJOIN("#", TRUE, B2, C2, D2)
• D. =TEXTJOIN("#", TRUE, B2:D2, E2)

Answer: (A)

TEXTJOIN is all about combining multiple text items into one string, using a delimiter between items and an option to skip empty cells. To join the three cells B2, C2, and D2 with a “#” between non-empty values, you set the delimiter to a hash, choose to ignore blanks, and feed the function the whole range B2:D2. That exact setup is what =TEXTJOIN("#", TRUE, B2:D2) does: it walks through B2, C2, and D2, inserts the delimiter between non-empty entries, and omits any blanks. If you used FALSE for ignore_empty, blanks would either appear as extra delimiters or as empty spots in the result. Listing each cell separately like B2, C2, D2 could work, but using the range B2:D2 is the cleanest way to target the entire set in one argument.

TEXTJOIN is all about combining multiple text items into one string, using a delimiter between items and an option to skip empty cells. To join the three cells B2, C2, and D2 with a “#” between non-empty values, you set the delimiter to a hash, choose to ignore blanks, and feed the function the whole range B2:D2. That exact setup is what =TEXTJOIN("#", TRUE, B2:D2) does: it walks through B2, C2, and D2, inserts the delimiter between non-empty entries, and omits any blanks. If you used FALSE for ignore_empty, blanks would either appear as extra delimiters or as empty spots in the result. Listing each cell separately like B2, C2, D2 could work, but using the range B2:D2 is the cleanest way to target the entire set in one argument.