Function

TextJoin2(rowDelimiter, colDelimiter, array) rowDelimiter colDelimiter array

---

Use

The TextJoin2() function combines the items in an array into a text value, with given delimiters between rows and columns.

The items in the array are expected to be text values, but if the items are number values, they will be converted to text values.

TextJoin() works similarly, but with only one given delimiter.

Examples

• TextJoin2("__", "**", ["A", "B"; "C", "D"])  = "A**B__C**D"
• TextJoin2("; ", " ", ["wish", "me"; "good", "morning"])  = "wish me; good morning"

 

 

---