Skip to content

=SPLIT

The SPLIT Function splits a string into sections and returns the specified section.

=SPLIT(CharacterToSplitOn; IndexOfSplitToReturn; TextToSplit)
  • CharacterToSplitOn: The character that the string will be split on

  • IndexOfSplitToReturn: The section of the split string you want to return

  • TextToSplit: The string you want to split

If you want to return all sections, enter 0 as IndexOfSplitToReturn

In the example above, if the TextToSplit was brown dog and blue fish, the function will return brown dog.