TEXTSPLIT |
TEXTSPLIT(input_text [,col_delimiter] [,row_delimiter] [,ignore_empty] [,pad_with]) |
Returns the text string split into multiple columns using delimiters. |
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: 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 |
|
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