|
SPLIT.TEXT Function
Splits a text string or a vertical or horizontal array/range of strings into horizontal/vertical arrays of string tokens, using a string of delimiters. Vertical arrays/ranges are split horizontally, Horizontal arrays/ranges are split vertically.
Each individual character in the delimiters string is used as an alternative delimiter.
Alphabetic characters used as delimiters are case-sensitive.
SPLIT.TEXT is a multi-threaded, non-volatile array function.
When using SPLIT.TEXT on a vertical array/range of strings a rectangular array is returned where the number of columns is the maximum number of tokens returned by any row in the vertical array/range.
SPLIT.TEXT on a horizontal array/range of strings returns a rectangular array where the number of rows is the maximum number of tokens returned by any column in the horizontal range.range.
Rows where the number of tokens returned is less than the maximum number of tokens returned across all rows will be padded out with empty string tokens.
SPLIT.TEXT Syntax
SPLIT.TEXT (Text, Delimiters, Count, Compress)
Text (Required)
The text string or vertical/horizontal array/range of strings to be split.
A 2-dimensional array or range returns #Value.
Delimiters
The list of delimiters to search for in the text string. Note that these delimiters are case-sensitive.
Count (Optional, default 0)
Integer. The position/number of string-tokens to return.
0 means return all tokens
+n means return the n’th token
-n means return the first n tokens
If Count is larger than the number of tokens for a row then an empty string is returned.
Compress (Optional, default TRUE)
If TRUE empty string tokens will be ignored.
|
