Which function is used to concatenate a range of text values with a delimiter while ignoring empty cells?

Which function is used to concatenate a range of text values with a delimiter while ignoring empty cells?

• A. CONCAT
• B. CONCATENATE
• C. TEXTJOIN
• D. JOIN

Answer: (C)

Text joining with a delimiter while skipping blanks is handled by a function that lets you choose both what to put between items and whether empty cells should be ignored. This function uses a delimiter parameter and a flag to ignore empty cells, making it ideal for turning a range into a single string without extra separators from blanks. Its syntax looks like this: TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...). When you pass a range, it goes through each cell, inserts the delimiter between nonempty values, and, if ignore_empty is TRUE, skips any empty cells so you don’t end up with consecutive delimiters. For example, =TEXTJOIN(", ", TRUE, A1:A10) will produce a single string of all nonempty values in A1:A10 separated by a comma and a space. This is exactly the behavior described: a range is concatenated with a delimiter, while empty cells are ignored. The other options don’t fit as cleanly. CONCAT and CONCATENATE join text together but do not automatically insert a delimiter between items, and they don’t offer a built-in way to ignore empty cells across a range. JOIN isn’t a standard Excel function for this purpose.

Text joining with a delimiter while skipping blanks is handled by a function that lets you choose both what to put between items and whether empty cells should be ignored. This function uses a delimiter parameter and a flag to ignore empty cells, making it ideal for turning a range into a single string without extra separators from blanks. Its syntax looks like this: TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...). When you pass a range, it goes through each cell, inserts the delimiter between nonempty values, and, if ignore_empty is TRUE, skips any empty cells so you don’t end up with consecutive delimiters.

For example, =TEXTJOIN(", ", TRUE, A1:A10) will produce a single string of all nonempty values in A1:A10 separated by a comma and a space. This is exactly the behavior described: a range is concatenated with a delimiter, while empty cells are ignored.

The other options don’t fit as cleanly. CONCAT and CONCATENATE join text together but do not automatically insert a delimiter between items, and they don’t offer a built-in way to ignore empty cells across a range. JOIN isn’t a standard Excel function for this purpose.