New Functions in Microsoft 365
You may not have (or see) all of these because some of them are very new and only available to Office Insiders.
| CHOOSECOLS | (2022) Returns the specified columns from an array. |
|---|---|
| CHOOSEROWS | (2022) Returns the specified rows from an array. |
| DROP | (2022) Returns the subset of continuous rows or columns from array start or end. |
| EXPAND | (2022) Returns the array expanded or padded to specific dimensions. |
| HSTACK | (2022) Returns the horizontal array formed by appending the array arguments. |
| TAKE | (2022) Returns the subset of contiguous rows or columns from the start or end of an array. |
| TEXTAFTER | (2022) Returns the characters from the end of a text string after a delimiter. |
| TEXTBEFORE | (2022) Returns the characters from the start of a text string before a delimiter. |
| TEXTSPLIT | (2022) Returns the text string split into multiple columns using delimiters. |
| TOCOL | (2022) Returns the column vector containing all the items in an array. |
| TOROW | (2022) Returns the row vector containing all the items in an array. |
| VSTACK | (2022) Returns the vertical array formed by appending the array arguments. |
| WRAPCOLS | (2022) Returns the column vector converted into a 2-dimensional array by column. |
| WRAPROWS | (2022) Returns the row vector converted into a 2-dimensional array by row. |
No comments:
Post a Comment