TEXTSPLIT Hack to make it Dynamic

TEXTSPLIT function

The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function.

https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7

New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)

Until now, splitting words to separate cells or breaking up long text strings in Excel using a delimiter was quite a challenge. We had to use functions like LEFT, MID, RIGHT, and so on, which are not easy to use. Especially if the text has multiple spaces or different delimiters. This is over now! With the new TEXTSPLIT function in Microsoft Excel it's so EASY now.

https://www.youtube.com/watch?v=xcVLWyEJHwY

Excel TEXTSPLIT Function

The Excel TEXTSPLIT function splits text by a given delimiter to an array that spills into multiple cells. TEXTSPLIT can split text into rows or columns.

https://exceljet.net/excel-functions/excel-textsplit-function