How to Split Text into Columns in Google Sheets?
Split Text to Columns is a Google Sheets function that splits the text in a specified cell into separate columns based on a chosen delimiter.. Formula Genius generates and validates this formula automatically from a plain-English prompt.
Struggling with text in a single cell? Use the SPLIT function to separate it into multiple columns effortlessly.
The Formula
"Split text in a cell by a delimiter (comma, space, dash) into separate columns using the SPLIT function in Google Sheets"
=SPLIT(A1, ", ")This formula splits the text in a specified cell into separate columns based on a chosen delimiter.
Step-by-Step Breakdown
- Identify the cell containing the text you want to split (e.g., A1).
- Choose the delimiter that separates the text (e.g., comma, space, dash).
- Use the SPLIT function to specify the cell and delimiter.
- The function will output the split text into adjacent columns.
Edge Cases & Warnings
- The delimiter appears multiple times in a row, resulting in empty columns.
- The text does not contain the specified delimiter, leading to no split.
- Using a delimiter that is part of the text itself may cause unexpected results.
- If the cell is empty, the function will return an empty cell.
Examples
"apple,banana,cherry"
apple | banana | cherry"one two three-four"
one | two | three | fourFrequently Asked Questions
Can I use multiple delimiters?
No, the SPLIT function only accepts one delimiter at a time.
What happens if there are no delimiters?
The entire text will remain in the original cell without splitting.
Is it possible to split text into rows instead of columns?
No, the SPLIT function only outputs results in columns.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.