TEXTSPLIT

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

Returns the text string split into multiple columns using delimiters.

input_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:
True = An empty cell will be included
False = An empty cell will not be included (default)
pad_with(Optional) The value with which to pad.

REMARKS
* Added in Microsoft 365 and is only available to Office Insiders at the moment.
* 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 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 delimiter).
* This function was released in March 2022.
* For the Microsoft documentation refer to support.microsoft.com

 A
1??


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