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.

Watch on YouTube & Subscribe to our Channel

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.

Search
Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter

Free Excel Training Webinar Modern Power Tools

>