TEXTSPLIT |
TEXTSPLIT(input_text [,col_delimiter] [,row_delimiter] [,ignore_empty] [,pad_with]) |
Returns the text string split into multiple columns using delimiters. |
input_text | The 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 |
|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top