Google Sheets SPLIT Function: Syntax, Examples & Tips

text:
The string or cell reference containing the text you want to split.

delimiter:
The character or characters that determine where the text should be split.

split_by_each:
(Optional) A boolean value that indicates whether to split by each character in the delimiter (TRUE) or to treat the entire delimiter as a single entity (FALSE). The default is TRUE.

remove_empty_text:
(Optional) A boolean value that specifies whether to remove empty text items from the result (TRUE) or to include them (FALSE). The default is TRUE.

What is the SPLIT Function?

The SPLIT function in Google Sheets is a useful tool that allows you to divide text strings into separate components based on a specified delimiter. This function is particularly helpful when you have data in a single cell that you want to break down into multiple cells for better analysis or organization.

In simpler terms, SPLIT enables you to take a long string of text and separate it into smaller, more manageable pieces.

A Practical Example

Imagine you have a list of full names in a single column, and you want to separate the first names and last names into two different columns.

Names Table:

SPLIT Formula

To achieve this, you would use the SPLIT function as follows:

=SPLIT(A2, " ")

In this formula:

• A2 is the cell containing the full name you want to split.
• " " is the delimiter, which in this case is a space character that separates the first name from the last name.

Result of the Formula

When you apply the SPLIT formula to the Names Table, the output would look like this:

As you can see, the full names have been successfully split into first and last names.

Why Use SPLIT?

SPLIT is beneficial because it simplifies the process of organizing and analyzing data that is stored in a single cell. It eliminates the need for manual separation of text and allows for quick data manipulation. This function is especially useful when dealing with imported data or when you need to prepare data for further analysis.

Key Takeaways:

• SPLIT: A Google Sheets function that divides text strings into separate components based on a specified delimiter.
• Easy to Use: Just specify the cell and the delimiter to separate the text.
• Data Organization: Helps in organizing data for better readability and analysis.
• Common Use Cases: Ideal for separating names, addresses, or any text strings that contain delimiters.

SPLIT is an essential function for anyone working with text data in Google Sheets, providing a straightforward way to enhance data organization and analysis.

Happy spreadsheeting!