Google Sheets SPLIT Function | Split Text based on One or More Delimiters | Spreadsheet Tutorial

Use the Google Sheets SPLIT function to split a text around a specified delimiter. This function places each split text part in a separate and an adjacent cell in the same row as the text.

To split, for example, first name, middle name and last name from a name; month, day, and year from a date; country code and telephone number from a mobile number, SPLIT function can be helpful.

-------------------------------------
The TEXTJOIN, JOIN, and CONCAT functions concatenates text.

Here is the link to the step-by-step tutorial on TEXTJOIN:

Here is the link to the step-by-step tutorial on JOIN:

Here is the link to the step-by-step tutorial on CONCAT:

-------------------------------------

The format of the SPLIT function formula is:

=SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

Start the formula with an equal-to symbol.

SPLIT is the name of the function.

text is the text you want to split.

delimiter is one or more character, based on which to split text. Here is a key point to note: In case of two or more characters, each character is a delimiter, if split_by_each attribute is set to true.

split_by_each is optional, and it can have a value of true or false. The
default is true. If true, and if the delimiter has more than one character,
the function splits the text by each individual character and its combinations.

remove_empty_text is optional, and it can have a value of true or false.
The default is true. If true, empty cells will not be included in the split result.

Let's look at an example of the SPLIT function formula:

=SPLIT("John Doe", " ")

Here the delimiter is an empty space.

The above formula splits the text "John Doe" by the empty space and places the first name John in a separate cell and last name Doe in an adjacent cell.

Take a look at this video tutorial, which gives the steps to use the Google Sheets SPLIT function with examples.