Divide text into separate columns by a delimiter.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])SPLIT breaks a string into multiple cells across columns. It's the formula-based Google Sheets counterpart to Excel's Text to Columns / TEXTSPLIT.
=SPLIT("a,b,c", ",")Result: a | b | c
Splits the string into three columns.
TEXTSPLIT (Microsoft 365) or the Text to Columns wizard.