You can either provide a column delimiter to split text into columns, or a row delimiter to split text into rows. To use TEXTSPLIT, you will need to provide the text to split and a delimiter.
TEXTSPLIT can split a text string into rows or columns.
The output from TEXTSPLIT is an array that will spill into multiple cells in the workbook. The TEXTSPLIT function splits a text string with a given delimiter into multiple values.
