Channel: MrExcel.com

Category: Howto & Style

Tags: unique of rectangular range in exceltextbefore function in exceltorow function in excelexpand function in excelmrexceldrop function in excelwrapcolsmicrosoft excelbill jelentextafter function in excelexcelchoosecols function in exceltocol function in exceltake function in exceltextsplit function in excelhstack function in excelwraprowssplit text in excel using a formulachooserows function in excelnew functions in excelvstack function in excel

Description: 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: support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7 TEXTBEFORE: support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29 TEXTAFTER: support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4 VSTACK: 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: support.microsoft.com/en-us/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2 CHOOSECOLS: 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: support.microsoft.com/en-us/office/chooserows-function-51ace882-9bab-4a44-9625-7274ef7507a3 DROP: support.microsoft.com/en-us/office/drop-function-1cb4e151-9e17-4838-abe5-9ba48d8c6a34 TAKE: support.microsoft.com/en-us/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003 EXPAND: support.microsoft.com/en-us/office/expand-function-7433fba5-4ad1-41da-a904-d5d95808bc38 TOCOL: support.microsoft.com/en-us/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed TOROW: support.microsoft.com/en-us/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289 WRAPCOLS: 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: 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