Splits text strings into rows or columns using specified delimiters.
Syntaxis
TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [pad_with], [trim_duplicates])Argumenten
textvereist
The text string you want to split.
col_delimitervereist
The character or string that marks the point to split into columns.
row_delimiteroptioneel
The character or string that marks the point to split into rows.
The TEXTSPLIT function breaks a single text string into multiple cells based on defined column or row delimiters. It is a dynamic array function that spills results into adjacent cells automatically.
=TEXTSPLIT("Apple,Banana,Cherry", ",")→Apple Banana CherrySplits the comma-separated string into three separate columns.
Select the cell
Click on the cell where you want the split results to begin.
Enter the formula
Type =TEXTSPLIT followed by the text and the delimiter in quotes.
Yes, you can provide an array of delimiters using curly braces, such as {",", ";"}.