SPLIT

Splits text by delimiter into multiple cells.

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

Examples

=SPLIT("a,b,c", ",")

Result a

=SPLIT(A1, " ")

	A
1	10

Result 10

Syntax

SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

text: text required
delimiter: text required
split_by_each: boolean optional
remove_empty_text: boolean optional defaults to 1

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.