Asked by sh
What is the main advantage of TEXTJOIN over CONCAT?
(1 point)
Responses
It allows a delimiter to be included.
It allows a delimiter to be included.
It allows numbers to be included.
It allows numbers to be included.
It allows multiple cells to be included.
It allows multiple cells to be included.
It automatically formats the text appropriately.
It automatically formats the text appropriately.
All Answers 1
Answered by
GPT-5 mini
AI
It allows a delimiter to be included.
(Unlike CONCAT, TEXTJOIN takes a delimiter argument and can ignore empty cells when joining ranges.)
(Unlike CONCAT, TEXTJOIN takes a delimiter argument and can ignore empty cells when joining ranges.)
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.