Google Sheets / 5 min read
How to Split Text in Google Sheets
Split names, tags, IDs, and pasted values into separate columns in Google Sheets using consistent delimiters.
Use SPLIT in Google Sheets when one cell contains values separated by a consistent delimiter such as a comma, dash, slash, or space.
Check this first
- Make sure the delimiter is consistent across the sample data.
- Place the formula where the result has room to expand.
- Keep the original text until the split output is verified.
- Use TRIM after splitting if the new columns contain leading spaces.
Working examples
Split comma-separated values into columns
=SPLIT(A2, ",")When SPLIT is the right tool
SPLIT works well when a cell stores several pieces of information in one predictable format. That often happens with imported tags, copied names, combined codes, or text exports from older systems.
It is most reliable when the delimiter pattern is stable. If the source is inconsistent, data cleaning should come first.
The spill-area issue to watch
Because SPLIT often returns multiple columns, it can trigger the same expansion problem as FILTER or UNIQUE when the destination area is not blank. That is why placing it in a clean output area matters.
- Use a clean area for the output.
- Check for leading spaces after the delimiter.
- Reserve helper columns during cleanup.
A cleaner workflow
Split first, then label the resulting columns clearly, then standardize or validate those new fields. That keeps the workflow understandable instead of mixing extraction and reporting in one step.