Jump to content
Business Intelligence & Analytics for Digital Transformation

14 new Excel functions designed to help you more easily manipulate text and arrays in your worksheets.

Recommended Posts

Green with Circles Promotion Announcement.png

Text Functions

  • TEXTBEFORE - Returns text that’s before delimiting characters
  • TEXTAFTER - Returns text that’s after delimiting characters
  • TEXTSPLIT - Splits text into rows or columns using delimiters

Array Manipulation Functions

Combining Arrays

  • VSTACK - Stacks arrays vertically
  • HSTACK- Stacks arrays horizontally

Shaping Arrays

  • TOROW - Returns the array as one row
  • TOCOL - Returns the array as one column
  • WRAPROWS - Wraps a row array into a 2D array
  • WRAPCOLS - Wraps a column array into a 2D array

Resizing Arrays

  • TAKE - Returns rows or columns from array start or end
  • DROP - Drops rows or columns from array start or end
  • CHOOSEROWS - Returns the specified rows from an array
  • CHOOSECOLS - Returns the specified columns from an array
  • EXPAND - Expands an array to the specified dimensions



These functions are currently available to users running Beta Channel, Version 2203 (Build 15104.20004) or later on Windows and Version 16.60 (Build 22030400) or later on Mac.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...