Announcing New Text and Array Functions for Excel

C

Costas

Administrator
Staff member
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
VSTACK - Stacks arrays vertically
HSTACK- Stacks arrays horizontally
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
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

https://techcommunity.microsoft.com...ing-new-text-and-array-functions/ba-p/3186066
 
You must log in or register to reply here.
Top