How to use the SPLIT() Function | Text-To-Columns Formula | Google Sheets Shorts

Описание: The SPLIT() function helps you to split text strings by a given delimiter, such as hyphen(-), comma (,), space ( ), semicolon (;) etc. Think of this as the formula version of the Text-To-Columns operation.

Using this, we can make the Text-To-Columns operation dynamic, enabling it to be used with other formulas.

I have also shown how you can use the INDEX() formula to limit the array output of this formula.