Syntax =TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with]) The TEXTSPLIT function syntax has the following arguments: text The text you want to split. Required. col_delimiter The text that marks the point where to spill the text across columns. row_delimiter The text that marks the point where to spill the text down rows. Optional. ignore_empty Specify TRUE to ignore consecutive delimiters. Defaults to FALSE, which creates an empty cell. Optional. match_mode Specify 1 to perform a case-insensitive match. Defaults to 0, which does a case-sensitive match. Optional. pad_with The value with which to pad the result. The default is #N/A. Remarks If there is more than one delimiter, then an array constant must be used. For example, to split by both...
Comments
Post a Comment