Wow... Amazing Excel TEXTSPLIT, HSTACK, TOROW and more new text and array functions

The Excel Insiders version has 14 new functions, I'll demonstrate a few of theme here 🔽 More Info below 🔽 TEXTBEFORE - Returns text that’s before delimiting characters TEXTAFTER - Returns text that’s after delimiting characters TEXTSPLIT - Splits text into rows or columns using delimiters TOROW - Returns the array as one row TOCOL - Returns the array as one column WRAPROWS - Wraps a row array into a 2D array WRAPCOLS - Wraps a column array into a 2D array VSTACK - Stacks arrays vertically HSTACK- Stacks arrays horizontally TAKE - Returns rows or columns from array start or end DROP - Drops rows or columns from array start or end CHOOSEROWS - Returns the specified rows from an array CHOOSECOLS - Returns the specified columns from an array EXPAND - Expands an array to the specified dimensions Official Blog Post: https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066 Find out more about Office Insiders here: https://insider.office.com/ My File (only useful if you have the functions available to you ) https://aasolutions.sharepoint.com/:x:/s/PubliclyAvailableContent/EfuM5SKKAuBHk90lTJIB2DUBKmh8G-87MgXoJ96kFf1XQQ?e=jPmpSo Connect with me https://wyn.bio.link/