TEXTSPLIT
Formulas / TEXTSPLITSplit 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?
What does the TEXTSPLIT function do?
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?
Does the TEXTSPLIT function work the same as the Text-to-Columns wizard?
