Bottom line: Microsoft just released 14 new Excel functions to help with extracting or splitting text and reshaping and combining arrays.
Skill level: Intermediate
The following video is a recording of a YouTube Live I did to demo the new functions.
In the video, I show some of the “old ways” of writing formulas and how the new functions make these tasks much easier.
The 14 New Functions
Here is a list of the new functions.
Text split and extract functions:
Array reshaping and combining:
Check out the video above to see examples of each function and how you can use them in your formulas.
The new functions are currently on the Insiders Beta channel for Excel for Windows and Mac. The Office Insiders program is free for all Microsoft 365 subscribers.