How to Split Text in Google Sheets | Google Sheets Tutorials
So, this time there are two ways to divide text in Google Sheets, namely using the "Split text to columns" menu and using the "Split" formula. The first way is as follows:
1. Highlight or select the text data you want to share,
2. Right-click on the mousepad or mouse, then click "Copy",
3. Move the cursor to the cell or column to place the text data you want to split, right click, then click "Paste",
4. Then select the "Data" menu, select the "Split text to columns" menu,
5. In the "Separator" menu display, change "Detect automatically" to "Space",
6. Done.
The second way is to use the following formula:
1. Point the cursor on the cell or column used to place the text data you want to share,
2. Type the formula "=SPLIT(select data from the cell/column you want to split, " ")". For example, we want to divide text data from cell/column "A2", then write it in the formula, namely "=SPLIT(A2, " ")".
3. Press the "Enter" key on the keyboard,
4. Done.
Hope it is useful.