Microsoft has introduced 14 new Excel functions for Office Insider members that can be used to assist with text and arrays.
Text manipulation functions
When working with text, a common task for users to accomplish is to “split” text strings using delimiters. Microsoft has released three functions that allow users to return everything before or after the delimiter selected by the user, and can also “split” text into multiple segments.
- TEXT BEFORE: Returns the text before the delimiter
- TEXT AFTER: Returns the text after the delimiter
- TEXTSPLIT: Easily “split” text into multiple segments
TEXTSPLIT Functionarray manipulation functions
to make it easier to build spreadsheets with dynamic arrays, Microsoft has released 11 new array manipulation functions.
Merge arrays
- VSTACK: Vertically merge arrays
- HSTACK: Merge arrays horizontally
Adjust the array form
- TOROW: Returns the array as a single row
- TOCOL: Returns an array as a column
- WRAPROWS: Wraps an array of rows into a two-dimensional array
- WRAPCOLS: Wraps arrays of columns into two-dimensional arrays
Resize the array
- TAKE: Returns rows or columns starting or ending from an array
- DROP: Deletes a row or column from the beginning or end of the array
- CHOOSEROWS: Returns the specified row from an array
- CHOOSECOLS: Returns the specified column from an array
- EXPAND: Extends the array to the specified dimension
These 14 new functions can be used in Office Beta Channel version 2203 (build 15104.20004) or later for Windows, and office 16.60 (build 22030400) or later for Mac.