Skip to content
Google Sheets functionNot in Excel

SPLIT function in Excel

Excel doesn't have SPLIT — here's what does.

Excel's TEXTSPLIT covers SPLIT — with one delimiter gotcha.

What SPLIT does in Google Sheets

Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

=SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

Convert SPLIT formulas to Excel

Before and after, formula by formula.

  1. Split on a comma:

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

  2. Split on several delimiters at once:

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

    SPLIT treats every character of the delimiter as its own splitter by default; TEXTSPLIT takes an array when you want that.

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

Browse Google Sheets text functions

More conversions to Excel