TEXTSPLIT

Splits text by delimiters into an array.

Excel: Not checked yet
Google Sheets: No equivalent
Returns: Array

Examples

=TEXTSPLIT("text", "text")

Result

Syntax

TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])

text: text required
col_delimiter: text required
row_delimiter: text optional
ignore_empty: boolean optional defaults to 0
match_mode: number optional
pad_with: any optional

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.