SPLIT function

Syntax

Arguments

How to use SPLIT

When SPLIT returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.

SPLIT takes 2 required arguments and 2 optional arguments. Type =SPLIT( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

Related text functions

• RIGHTReturns the last characters of a text.
• RIGHTBSame as RIGHT, counting bytes; without a double byte language set as default each character counts as one byte.
• SEARCHReturns the position of one text inside another, ignoring case. Accepts the wildcards ? and *.
• SEARCHBSame as SEARCH, counting bytes; without a double byte language set as default each character counts as one byte.
• SUBSTITUTEReplaces existing text with new text, everywhere or only in one occurrence.
• TReturns the value if it is text, otherwise empty text.
• TEXTFormats a number as text with a number format code, like "$#,##0.00" or "yyyy-mm-dd".
• TEXTAFTERReturns the text that comes after a delimiter.
• TEXTBEFOREReturns the text that comes before a delimiter.