The TEXTSPLIT function is one of Excel's text functions.
The TEXTSPLIT function works in the same way as the text-to-columns functionality in native Excel or split-by functionality in PowerQuery. It allows you to split values from a cell across rows and/or columns based on a delimiter.
The function makes use of Excel' dynamic array functionality to "spill" the results aross rows and columns.
TEXTSPLIT is a great improvement on using other text functions such as LEFT, RIGHT, MIDDLE etc to split text out from a cell.
Here's a simple example
Let's take a look at a simple example of the TEXTSPLIT function.
We would like to split the three words in cell A1 out across three separate cells, firstly across columns and secondly down rows.
What does that mean in plain English?
Split the three words in cell A1 out across three separate cells, firstly across columns and secondly down rows.
Now lets look at a slightly more complicated example where we want to split by columns and rows
We would like to split the three words in cell A1 out over both rows and columns. We will split across columns using a space delimiter " " and down rows using the hyphon "-" delimiter.
How do I write a formula using the TEXTSPLIT function?