TextJoin
TextJoin-func
Description
This function is used to join two or more texts, seperated by specified delimeter.
Syntax
string TextJoin(StringArray|String delim, bool empty, StringArray text )$
string TextJoin(StringArray|String delim, bool empty, String text1$, ... )$
Parameters
delim
- is the delimiter used to join text. Must be enclosed in double quotation. If space is specified, join texts continuely. If numeric is specified, it will be treated as text.
empty
- determines whether or not to trim space in the text. 1 = trim all space inside text. 0 = keep space as it is.
text
- string or string array to be joint.
Return
return text constructed by joining the given texts, seperated by specified delimeter.
Examples
- Create a new worksheet. Fill the first two rows of col(A) with text aa and bb.
- Type formula
TextJoin(",", 1, A1$, A2$)$
in F(x) cell of col(B).