Skip to content
Excel functionNot in Google Sheets

TEXTSPLIT function in Google Sheets

Google Sheets doesn't have TEXTSPLIT — here's what does.

Google Sheets' SPLIT covers TEXTSPLIT — mind the delimiter mode.

What TEXTSPLIT does in Excel

Splits text strings by using column and row delimiters

=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])

Convert TEXTSPLIT formulas to Google Sheets

Before and after, formula by formula.

  1. Split on a comma:

    Excel
    =TEXTSPLIT(A2, ",")
    Google Sheets
    =SPLIT(A2, ",")

  2. Keep a multi-character delimiter whole:

    Excel
    =TEXTSPLIT(A2, " - ")
    Google Sheets
    =SPLIT(A2, " - ", FALSE)

    Pass FALSE for split_by_each — Sheets otherwise splits on every character of the delimiter.

Worth knowing

  • TEXTSPLIT's row_delimiter (splitting into rows AND columns at once) has no SPLIT equivalent — split rows first, then map SPLIT over them.

Converting more than one formula? The Excel ↔ Sheets translator rewrites whole workbooks and flags every TEXTSPLIT so none slip through silently.

Browse Excel text functions

More conversions to Google Sheets