Saurabh Jain Posted March 17, 2022 Share Posted March 17, 2022 Text Functions 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 Array Manipulation Functions Combining Arrays VSTACK - Stacks arrays vertically HSTACK- Stacks arrays horizontally Shaping Arrays 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 Resizing Arrays 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 Availability These functions are currently available to users running Beta Channel, Version 2203 (Build 15104.20004) or later on Windows and Version 16.60 (Build 22030400) or later on Mac. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.