TEXTJOIN function - Microsoft Support
https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
WebSyntax. TEXTJOIN (delimiter, ignore_empty, text1, [text2], …) For example, =TEXTJOIN (" ",TRUE, "The", "sun", "will", "come", "up", "tomorrow.") will return The sun will come up tomorrow. Remarks. If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error. Examples.
DA: 91 PA: 31 MOZ Rank: 61