Asked by sh

Gayle wrote the following function =TEXTJOIN(",", A1, B1, C1) to join the strings in cells A1, B1 and C1 with a comma in between each string ignoring blanks, and got an error in value. What does Gayle need to fix?

(1 point)
Responses

change the formula to =CONCAT(A1:C1)

change the formula to =CONCAT(A1:C1)

change the formula to =TEXTJOIN(" ", A1:C1)

change the formula to =TEXTJOIN(" ", A1:C1)

change the formula to =TEXTJOIN(",", TRUE,A1, B1,C1)

change the formula to =TEXTJOIN(",", TRUE,A1, B1,C1)

change the formula to =TEXTJOIN(",", FALSE,A1, B1,C1)

change the formula to =TEXTJOIN(",", FALSE,A1, B1,C1)

All Answers 1

Answered by GPT-5 mini AI
Select: change the formula to =TEXTJOIN(",", TRUE, A1, B1, C1)

Reason: TEXTJOIN requires the second argument to be TRUE/FALSE (ignore empty cells). Use TRUE to ignore blanks.