TEXTSPLIT

Formulas / TEXTSPLIT
Split text using a delimiter.
==TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
  • text - required, the text to split
  • col_delimiter - required, character(s) that indicates where to divide text across columns
  • row_delimiter - [OPTIONAL] character(s) that indicates where to split the text across the rows in a table
  • ignore_empty - [OPTIONAL]
  • match_mode - [OPTIONAL]
  • pad_with - [OPTIONAL]

Examples

  • =TEXTSPLIT(B3,",")

    The TEXTSPLIT function takes a text string and separates it into individual pieces based on a delimiter. The text string in cell B3 is split into individual pieces separated by a comma. The result is a set of values {"Red","Blue","Green"}.

  • =TEXTSPLIT(B3,,",")

    The text string in cell B3 is split into individual pieces separated by a semicolon. The result is a set of values {"Red";"Blue";"Green"}.

  • =TEXTSPLIT(B3,",",,TRUE)

    The TEXTSPLIT function also allows you to ignore empty values. The text string in cell B3 is split into individual pieces separated by a comma and any empty values are ignored. The result is a set of values {"Red","Blue","Green"}.


Summary

The Text-split function is a tool that works the same way as the Text-to-Columns wizard, allowing users to quickly divide text into separate columns.

  • TEXTSPLIT splits text by a delimiter into an array of text strings that spill into multiple cells, rows, or columns.
  • The last argument for TEXTSPLIT is pad_with, which is optional.
  • The output from TEXTSPLIT is an array that is split into multiple cells.

Frequently Asked Questions

What is the TEXTSPLIT function?
The TEXTSPLIT function is a function used to split text strings by using column and row delimiters. It is the inverse of the TEXTJOIN function and works the same as the Text-to-Columns wizard.
What does the TEXTSPLIT function do?
The TEXTSPLIT function splits text across columns or down by rows. It takes a text string and breaks it into separate cells based on the specified column and row delimiters.
What are some examples of using the TEXTSPLIT function?
  • Splitting a single cell that contains a list of items into separate cells for each item.
  • Breaking apart a sentence into its individual words.
  • Separating a long string of numbers into separate cells.
What are the parameters of the TEXTSPLIT function?
The TEXTSPLIT function has two parameters: the text string to be split and the delimiters to be used for splitting. The delimiters can be either a comma, a space, a tab, or a semicolon.
Does the TEXTSPLIT function work the same as the Text-to-Columns wizard?
Yes, the TEXTSPLIT function works the same as the Text-to-Columns wizard.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV