What is the SPLIT Formula? The SPLIT function helps you to quickly and easily separate text into columns based on a delimiter. The delimiter is a character (or characters) you choose by which you want to cut the text. The syntax of the SPLIT function is: =SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

The SPLIT function in Google Sheets returns a division of text around a specified character or characters, distributing each fragment into a separate cell in the row. This function is particularly useful when you have a cell filled with text that you want to divide into smaller, more manageable pieces.

Syntax of the SPLIT Function in Google Sheets The basic syntax of the SPLIT function is: =SPLIT(text, delimiter, [split_by_each], [remove_empty_text]) Let's break down each parameter: text: This is the text or cell reference that you want to split. delimiter: This is the character or string that specifies where to split the text.