TEXTSPLIT

TEXTSPLIT(input_text [,col_delimiter] [,row_delimiter] [,ignore_empty] [,pad_with])

Returns the text string split into multiple columns using delimiters.

textThe text you want to split.
col_delimiter(Optional) One or more characters that specify where to spill the text across columns.
row_delimiter(Optional) One or more characters that specify where to spill the text down rows.
ignore_empty(Optional) A logical value indicating whether to ignore consecutive delimiters:
False (or 0) = An empty cell will not be included (default)
True (<> 0) = An empty cell will be included
match_mode(Optional) The match mode to use:
0 = Case Sensitive (default)
1 = Not Case Sensitive
pad_with(Optional) The value with which to pad.

REMARKS
* This function was added in Microsoft 365.
* This function can create a Dynamic Array Formula.
* This function works in a similar way to the Text to Columns Wizard.
* If "col_delimiter" is left blank, then
* If "row_delimiter" is left blank, then
* If you want to have more than one delimiter, then an array constant must be used {"delimiter1","delimiter2"}.
* If "ignore_empty" is left blank, then False is used.
* If "ignore_empty" is True then an empty cell will be created when two delimiters are consecutive.
* If "ignore_empty" is False then an empty cell will not be created when two delimiters are consecutive.
* If "pad_with" is left blank, then #N/A is used.
* You can use the CONCAT function to return a concatenation of strings (without any delimiters).
* You can use the TEXT function to return a number as a formatted text string.
* You can use the TEXTAFTER function to return the characters from the end of a text string after a delimiter.
* You can use the TEXTBEFORE function to return the characters from the start of a text string before a delimiter.
* You can use the TEXTJOIN function to return the text string that is a concatenation of several strings with a delimiter.
* This function was first released in March 2022.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=TEXTSPLIT("better solutions"," ") = {"better", "solutions"}
2=TEXTSPLIT("ab cd ef gh"," ") = {"ab","cd","ef","gh"}
3=TEXTSPLIT("one,two,three",",") = {"one","two","three"}
4=TEXTSPLIT("one,two,three",,",") = {"one" ; "two" ; "three"}

1 - What is this text string split using the column delimiter " ".
2 - What is the text string split using the column delimiter " ".
3 - What is the text string split using the column delimiter ",".
4 - What is the text string split using the row delimiter ",".

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top