TEXTSPLIT Hack to make it Dynamic

The new TEXTSPLIT function in Excel is one of 14 new functions just released. Here's my hack to make it fully dynamic. Excel Blog Post https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066 Connect with me https://wyn.bio.link/ https://accessanalytic.com.au/ Did you know I've written a book "Power BI for the Excel Analyst"? https://pbi.guide/book/