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/t...
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/