3.5.7.37 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

1. Create a new worksheet. Fill the first two rows of col(A) with text aa and bb.
2. Type formula

   TextJoin(",", 1, A1$, A2$)$

   in F(x) cell of col(B).