To use the Google Sheets SPLIT function, select a blank cell, go to the

Formulabar, enter the formula=SPLIT(A1,” “), and pressEnter.

Here is a step-by-step tutorial that will guide you through the process of using the SPLIT function in Google Sheets and all the details related to it. Scroll down to find out more!

## How to Quickly Use the SPLIT Function in Google Sheets

Check out the methods of using this function and pick the one that works best for you.

**Difficulty**: Beginner

**Time Estimate**: 5 seconds

- Click on the cell where you need to get the result.
- Navigate to the
**Formula**bar and enter the formula**=SPLIT(A1,” “)**, where**A1**is the cell with your text that you want to split.

- Hit the
**Enter**key on your keyboard.

If you have a set of data rather than a single cell, you can take the next step to apply the function to all cells:

- Drag the cell with the result downward from the icon in the bottom right of the cell to copy the formula into the remaining cells.

Voila! And here is the result.

## Drilling Down into the SPLIT Function

### Description

The SPLIT function is a built-in function in Google Sheets that allows you to split a single cell or string of text into multiple cells based on a delimiter (such as a space or a comma).

For example, if you have a list of names in one cell and you want to split them into separate cells, you can use the SPLIT function. Let’s take a look at the screenshot below:

### Purpose

Google Sheets’ SPLIT function lets you split a cell or string by a character. This can be useful when dealing with large amounts of text data that need to be parsed in some way.

### Syntax

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

### Arguments

**text**is the text you need to split.**delimiter**is the character that will separate your text values (such as a space or a comma).

**split_by_each**is a TRUE element that is not mandatory in the formula, but it helps to determine whether it is necessary to split the text.

**remove_empty_text**is an optional TRUE element in the formula which determines whether empty text values need to be avoided.

### Return Value

You will get text values that are split into separate cells when using this function.

### Usage Notes

- When entering text values into the formula, do not forget to put the quotation marks; otherwise, the function will not work.
- Characters that are near the text value will be omitted.

### Examples

- Using the formula that we used below, you can separate the words in the cell.

=SPLIT(A1,” “) // Output: James Davis

- As a second example, we will consider the following formula:

=SPLIT(A1,”, “, TRUE, FALSE) // Output: James Davis

- Here is a formula for separating individual values of text:

=SPLIT(“A, B, C, D, E, F”, “, “) // Output: A B C D E F

## SPLIT Function in Google Sheets FAQs

Visit our FAQ section to learn more!

### How do I split numbers in Google Sheets?

To split numbers in Google Sheets, select the cell where you need to get the result, move to the **Formula** bar, and type the formula **=SPLIT(“12, 13.5, 14, 15.7, 18, 19.5”, “, “)**, using your own values. Finally, hit **Enter**.

### How do I extract the N-th word in a sentence in Google sheets?

To extract the N-th word in a sentence in Google Sheets, first click on a blank cell where you want the result. Then, in the **Formula** bar, enter the formula **=INDEX(SPLIT(A1,” “),1,6),** where **A1** is the cell with your sentence, and **6** is the word you need to extract. Next, press **Enter**.

And here is the result!

### How do I split a cell into multiple rows vertically with the formula in Google Sheets?

To split a cell into multiple rows vertically with the formula in Google Sheets, start by selecting a blank cell, go to the **Formula** bar, and enter the formula **(=TRANSPOSE(SPLIT(A1,”,”)))**. Here, **A1** is the cell with your text. Finally, press the **Enter** key on your keyboard.

Congratulations! You have done it!