Google Sheets functions / Text
Text function · Google Sheets
SPLIT function
Splits text into separate cells.
Availability
| Platform | Status |
|---|---|
| Excel | Not listed |
| Google Sheets | Listed |
On Excel: use TEXTSPLIT. Excel treats the delimiter as one whole string by default.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.