Скачать или смотреть Excel Tips: Textsplit part4

Excel formula Textsplit context and usage as below.

   • Excel Tips: Textsplit #excelformula #excel...  

Purpose :

Split a text string with a delimiter

Return value :

Text in multiple cells

Arguments :

text - The text string to split.
col_delimiter - The character(s) to delimit columns.
row_delimiter - [optional] The character(s) to delimit rows.
ignore_empty - [optional] Ignore empty values. TRUE = ignore, FALSE = preserve. Default is FALSE.
match_mode - [optional] Case-sensitivity. 0 = enabled, 1 = disabled. Default is 0.
pad_with - [optional] Value to pad missing values in 2d arrays.


Syntax :

=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
Usage notes
The TEXTSPLIT function splits a text string with a given delimiter into multiple values. The output from TEXTSPLIT is an array that will spill into multiple cells in the workbook. TEXTSPLIT can split a text string into rows or columns.

Reference : https://exceljet.net/functions/textsp...