This wikiHow teaches you how to use the SPLIT function in Google Sheets to split multiple words or characters in the same cell into separate cells, using Android.
Steps
-
Open the Google Sheets app on your Android. The Sheets icon looks like a green sheet with a white table on it. You can find it on your Apps menu.
- If the Sheets app opens up to a spreadsheet you were previously viewing, tap the back button to go back to your home screen.
-
Tap thebutton. It's located in the lower-right corner of your screen.Advertisement
-
Tap New spreadsheet . This will open a new spreadsheet document.
- Alternatively, you can open a spreadsheet you've created before in your Sheets app.
-
Double tap an empty cell. This will highlight the cell, and bring up your keyboard.
-
Enter two words in the empty cell, separated by an underscore. The SPLIT function will let you separate these two words into two different cells.
- For example, if the two words you want to split into separate cells are Word1 and Word2 , type Word1_Word2 in the empty cell.
- Feel free to use a different punctuation to separate your words or characters. Try using a comma or a period to see which one works best for you.
-
Tap another empty cell. You will be inserting your split function into this new cell. Your first word or character will be copied here when you split your initial cell.
-
Tap the fx icon. This button is located next to the formula field in the lower-left corner of your spreadsheet. It will open the "Insert function" page.
-
Tap thebutton. It's in the upper-right corner of your screen. This button will let you enter a keyword and search a function to insert.
-
Type SPLIT in the search field. All matching results will appear in a drop-down below the search bar.
-
Tap SPLIT in the results. This will insert the SPLIT function into the empty cell you've selected.
-
Tap the cell with the words you want to split in it. It will highlight this cell with red, and insert the cell name into your SPLIT function.
- For example, if the words or characters you want to split are in the A1 cell, your SPLIT function will now read =SPLIT(A1) .
-
Add a comma after the cell name in your SPLIT function. This will let you indicate the punctuation mark you're using between the two words, and tell the SPLIT function where to split your cell.
-
Type "_" after the comma in your SPLIT function. This way, the SPLIT function will split the words in the A1 cell, using the underscore as the point of separation.
- For example, if your initial cell is A1, your SPLIT function should now read =SPLIT(A1,"_") .
- Instead of searching all the functions, you can also just type =SPLIT(A1,"_") into an empty cell. It will save you some extra time.
- If you're using a different punctuation, replace the underscore in the above function with the one you're using. For example, if you're using a period to split your words, your function should read =SPLIT(A1,".") .
-
Tap the blue checkmark next to the function field. This will confirm your completed SPLIT function, and split the words in your initial cell into new, separate cells.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Warnings
- If you want to split more than two words or characters, separate each one with the same punctuation mark. If you're using an underscore to separate your first and second words, don't switch from an underscore to a period between your second and third words.Thanks
Advertisement
About this article
Article Summary
X
1. Open the Google Sheets app.
2. Tap the " +
" icon.
3. Tap New spreadsheet
.
4. Tap the A1 cell.
5. Type Word1_Word2
in the A1 cell.
6. Tap another empty cell.
7. Type =SPLIT(A1,"_")
.
8. Tap the checkmark in bottom-right.
Did this summary help you?
Thanks to all authors for creating a page that has been read 16,270 times.
Advertisement
