14 New Excel Functions: Text Split and Array Processing

Bottom line: Microsoft just released 14 new Excel functions to help with extracting or splitting text and reshaping and combining arrays.

Skill level: Intermediate

Live Video

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:

1. TEXTSPLIT
2. TEXTBEFORE
3. TEXTAFTER

Array reshaping and combining:

1. VSTACK
2. HSTACK
3. TOROW
4. TOCOL
5. WRAPROWS
6. WRAPCOLS
7. TAKE
8. DROP
9. EXPAND
10. CHOOSEROWS
11. CHOOSECOLS

Check out the video above to see examples of each function and how you can use them in your formulas.

Availability

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.