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:
techcommunity.microsoft.com/t...
Find out more about Office Insiders here: insider.office.com/
My File (only useful if you have the functions available to you ) aasolutions.sharepoint.com/:x...
Connect with me
wyn.bio.link/
5 авг 2024