Skip to content
ExcelExcel 2024+

TEXTSPLIT function in Excel

Splits text strings by using column and row delimiters

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

TEXTSPLIT syntax and parameters

Six arguments, two required.

  • textstringRequired
  • col_delimiterstringRequired
  • row_delimiteranyOptional
  • ignore_emptyanyOptional
  • match_modeanyOptional
  • pad_withanyOptional

TEXTSPLIT examples

Formulas you'll actually reuse.

  1. A comma-separated tag list into separate cells across the row:

    =TEXTSPLIT(A2, ", ")

  2. key=value;key=value pairs into a two-column grid — column delimiter, then row delimiter:

    =TEXTSPLIT(A2, "=", ";")

TEXTSPLIT in Google Sheets

No direct equivalent — here's the way around.

Try TEXTSPLIT in the playground

Edit the example — nothing to install.

Preloaded with the TEXTSPLIT formula from Example 1 — change anything and watch it respond.

Loading the editor…

TEXTSPLIT errors

What they mean — and the fixes.

  • #N/A

    The rows split to different lengths and no pad_with was given — pass "" as the sixth argument.

Related functions

More ways Excel gets this done.