SPLIT Function: Split Text in Google Sheets by Specified Delimiters

About the SPLIT Function

Overview of SPLIT

Split Text Using DelimitersGoogle Sheets Function

=SPLIT( text, delimiter, [split_by_each], [remove_empty_text] ) Summary The SPLIT function divides a string into separate components based on a specified delimiter and places each part into a separate cell.

Efficiently splits strings based on a delimiter. Useful for organizing and reformatting data. Ideal for processing CSV data or analyzing complex text strings.

When to Use SPLIT

• When splitting text into components based on a specific delimiter.
• To process or analyze text data effectively.
• When multiple values are entered in a single cell, and you need to separate them for better organization.

How to Use SPLIT

The following example demonstrates the basic usage of the SPLIT function.

	A	B	C	D
1	Data	Split 1	Split 2	Split 3
2	John,Emily,Michael	=SPLIT(A2, “,”)

Results

• The text in cell A2, “John,Emily,Michael,” is split based on the delimiter “,”.
• Cell B2 contains “John,” cell C2 contains “Emily,” and cell D2 contains “Michael.”

Advanced Usage of SPLIT

Below are examples demonstrating advanced use cases for the SPLIT function:

	A	B	C	D
1	Data	Item 1	Item 2	Item 3
2	apple;orange;banana	=SPLIT(A2, “;”)

Results

• The text in cell A2, “apple;orange;banana,” is split based on the delimiter “;.”
• Cell B2 contains “apple,” cell C2 contains “orange,” and cell D2 contains “banana.”

Points to Note

• If the delimiter is not found in the text, the entire string remains in one cell.
• Only one delimiter can be specified at a time.
• If spaces are used as the delimiter, multiple consecutive spaces are treated as a single delimiter when “split_by_each” is set to TRUE.

Conclusion

• The SPLIT function is a convenient tool for splitting strings by delimiters and organizing data.
• It is highly effective for processing and analyzing text data.
• Its simplicity makes it ideal for handling complex text processing tasks.