Match_mode (optional) - determines case-sensitivity for the delimiter. don't create empty cells for two or more consecutive delimiters. FALSE (default) - create empty cells for consecutive delimiters without a value in-between.Ignore_empty (optional) - specifies whether to ignore empty values or not: Row_delimiter (optional) - a character(s) that indicates where to split the text across rows. If omitted, row_delimiter must be defined. Can be supplied as a string or cell reference.Ĭol_delimiter (required) - a character(s) that indicates where to split the text across columns.
