TEXTSPLIT function
Splits text strings by using column and row delimiters
Syntax
TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| text | Yes | The text to split.A1:C2 |
| col_delimiter | Yes | The character or string by which to split the column."," |
| row_delimiter | No | The character or string on which to split the line.";" |
| ignore_empty | No | Whether to ignore empty cells. The default is FALSE. |
| match_mode | No | Searches for a delimiter match in the text. By default, a case-sensitive match is done. |
| pad_with | No | The value to use for padding. By default, #N/A is used. |
Try TEXTSPLIT
Preserve empty records and pad shorter rows
=TEXTSPLIT(A2,"|",CHAR(10),FALSE,0,"")FALSE keeps blank fields and records. Short rows receive empty text padding, and the final LF produces a fourth record; the full four-by-three shape is checked.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
TEXTSPLIT · top-level call
=TEXTSPLIT(A2,"|",CHAR(10),FALSE,0,"")Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.