Reference
No results for 'undefined'
    Powered by Algolia

    SPLIT

    Divides text around a specified character or string, returns a frame with all the fragments.

    Syntax

    =SPLIT(Text, Delimeter, [splitByEach], [removeEmptyText])

    Parameters

    1. Text
      • Type: String
      • Description: The text to divide.
    2. Delimeter
      • Type: String
      • Description: The character or characters to use to split text. By default, each character in delimiter is considered individually, e.g. if delimiter is "the", then text is divided around the characters "t", "h", and "e". Set splitByEach to FALSE to turn off this behavior.
    3. splitByEach [optional]
      • Type: Boolean
      • Description: Whether or not to divide text around each character contained in delimiter. TRUE by default
    4. removeEmptyText [optional]
      • Type: Boolean
      • Description: Whether or not to remove empty text messages from the split results. The default behavior is to treat consecutive delimiters as one (if TRUE). If FALSE, empty cells are added between consecutive delimiters. TRUE by default

    Returns

    • Type: Frame
    • Description: Returns the concatenated string

    Example

    =SPLIT("1,2,3", ",")

    Try It Now

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

    See Also

    Contents