With reference to the TEXTJOIN function in MS Excel 2021, which of the following statements are true?
1
The resulting string can have upto 35767 characters.
2
TEXTJOIN is similar to the CONCATENATE function but the former function provides a delimiter.
3
This function also allows non-printable characters as delimiters.
4
You can set a condition as an argument to combine the text in the syntax itself.