New Functions in Excel

14 New Function in Excel:

Text functions
1. TEXTBEFORE: returns text that’s before delimiting characters
TEXTBEFORE(text, delimiter, [instance number], [ignore case])

2. TEXTAFTER: returns text that’s after delimiting characters
TEXTAFTER(text, delimiter, [instance number], [ignore case])

3. TEXTSPLIT: splits text into rows or columns using delimiters.
TEXTSPLIT(text, [column delimiter], [row delimiter], [ignore empty], [pad with])

Combining Arrays
4. HSTACK: combine dynamic arrays, stacking horizontally
HSTACK(array1, [array2, …])

5. VSTACK: combine dynamic arrays, stacking vertically.
VSTACK(array1, [array2, …])

Shaping Arrays
6. TOCOL: convert a two-dimensional array into a single column (list) of data
TOCOL(array, [ignore], [scan by column])

7. TOROW: convert a two-dimensional array into a single row (list) of data
TOROW(array, [ignore], [scan by column])

8. WRAPCOLS: creates a two-dimensional array of a specified height by wrapping data from a column (list) of data once the prescribed height is achieved (this is essentially the opposite of the TOCOL or TOROW functions)
WRAPCOLS(vector, wrap count, [pad with])


9. WRAPROWS: creates a two-dimensional array of a specified width by wrapping data from a row (list) of data once the prescribed width is achieved (this is essentially the opposite of the TOCOL or TOROW functions).
WRAPROWS(vector, wrap count, [pad with])

Resizing Arrays
10. CHOOSECOLS: returns the specified rows from an array
CHOOSECOLS(array, column number 1, [column number 2, …])

11. CHOOSEROWS: returns the specified columns from an array
CHOOSEROWS(array, row number 1, [row number 2, …])

12. DROP: drops rows or columns from an array start or end
DROP(array, rows, [columns])

13. EXPAND: expands an array to the specified dimensions
EXPAND(array, rows, [columns], [pad with])

14. TAKE: returns rows or columns from the start or end of an array.
TAKE(array, rows, [columns])