You can split text in Google Sheets in a couple of different ways. Let's see how it works and how you can use it.
First things first: Open your spreadsheet document.
2
Once you open your Google Spreadsheet, select the cell where you want to apply the Split function.
3
Then, you should type "=split"
4
You will see the SPLIT option below the cell. Click on it.
5
Once you do that, you will see the syntax of the formula. So, to apply it in this case, it would be this:
- =SPLIT(G22,",")
6
Type the formula and then hit enter.
7
You will get you text split into different cells! That's all!
8
But wait! There's another way do split your text without a formula! First, click on the cell where is the text that you want to split!
9
Then, click on "Data".
10
Now, click on "Split text into columns".
11
You will get your text split! You can also choose what you want your text separator to be by clicking on "Separator".
12
And selecting the option you prefer from the dropdown. It's that easy!