Reference
No results for 'undefined'
    Powered by Algolia

    JOIN

    Concatenates the elements of one or more frames-or-ranges using a specified separator.

    Syntax

    =JOIN(Separator, Frames, Frames, ...)

    Parameters

    1. Separator
      • Type: String
      • Description: Separator to join with
    2. Frames [repeatable]
      • Type: Frame
      • Description: Frames to join

    Returns

    • Type: String
    • Description: Returns the joined string

    Example

    =JOIN("-",A1:A100)

    See Also

    Contents