Fourteen new functions in Excel: TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, CHOOSECOLS, CHOOSEROWS, DROP, TAKE, EXPAND, TOCOL, TOROW, WRAPCOLS, WRAPROWS.
Links to Help topic for each:
TEXTSPLIT: https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
TEXTBEFORE: https://support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29
TEXTAFTER: https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4
VSTACK: https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c?ns=xlwaenduser&version=16&ui=en-us&rs=en-us&ad=us
HSTACK: https://support.microsoft.com/en-us/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2
CHOOSECOLS: https://support.microsoft.com/en-us/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff?ns=xlwaenduser&version=16&ui=en-us&rs=en-us&ad=us
CHOOSEROWS: https://support.microsoft.com/en-us/office/chooserows-function-51ace882-9bab-4a44-9625-7274ef7507a3
DROP: https://support.microsoft.com/en-us/office/drop-function-1cb4e151-9e17-4838-abe5-9ba48d8c6a34
TAKE: https://support.microsoft.com/en-us/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003
EXPAND: https://support.microsoft.com/en-us/office/expand-function-7433fba5-4ad1-41da-a904-d5d95808bc38
TOCOL: https://support.microsoft.com/en-us/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed
TOROW: https://support.microsoft.com/en-us/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289
WRAPCOLS: https://support.microsoft.com/en-us/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2?ns=xlwaenduser&version=16&ui=en-us&rs=en-us&ad=us
WRAPROWS: https://support.microsoft.com/en-us/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0
Table of Contents
(0:00) Overview of 14 functions
(1:00) Split text with TEXTSPLIT
(2:17) Join arrays into a column with TOCOL
(2:42) Stack arrays with HSTACK
(2:58) DROP the first row
(3:10) TEXTBEFORE and TEXTAFTER
(4:20) HSTACK and VSTACK
(4:35) DROP function
(5:29) TAKE Function
(6:20) CHOOSEROWS & CHOOSECOLS Functions
(7:10) TOCOL and TOROW functions
(8:20) Shuffle and deal a deck of cards
(9:10) WRAPCOLS function
(10:10) Will make Excel easier
(10:50) UNIQUE of a rectangular range
(11:05) TEXTSPLIT
(11:39) Flighted to part of Insiders