Reference
No results for 'undefined'
    Powered by Algolia

    TEXTJOIN

    Joins strings using the separator. If ignoreEmpty is TRUE, empty cells selected in the text arguments won't be included in the result.

    Syntax

    =TEXTJOIN(Separator, Ignore empty, Strings, Strings, ...)

    Parameters

    1. Separator
      • Type: String
      • Description: Separator to join with
    2. Ignore empty
      • Type: Boolean
      • Description: Ignore empty
    3. Strings [repeatable]
      • Type: Any
      • Description: Strings to join

    Returns

    • Type: String
    • Description: Returns the joined string

    Example

    =TEXTJOIN(" ", TRUE, "hello", "world")

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.

    See Also

    Contents