AI · 1 min read

SPLIT

SPLIT function in Google Sheets: Splits text into separate cells.

Text function · Google Sheets

SPLIT function

Splits text into separate cells.

Availability

PlatformStatus
ExcelNot listed
Google SheetsListed
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.