Microsoft Just announced today (16 March 2022) the release of 14 amazing new TEXT Functions that can be categorized as:
14 New Text Functions:
Here are some of the new text functions Microsoft released. Lets dive right in.
Text Manipulation functions:
TEXTBEFORE / TEXTAFTER / TEXTSPLIT
TEXTBEFORE: Learn More ► https://support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29
Array manipulation Functions
These can be divided into combining arrays, Shaping Arrays or Resizing Arrays:
VSTACK / HSTACK
TOROW / TOCOL / WRAPROWS / WRAPCOLS
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.
Don’t have it yet? It’s probably us, not you.
Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes Microsoft removes elements to further improve them based on the feedback they receive.
I’m not among the lucky ones.
At the time of writing this article, I do not have these functions yet. Once I get them I will be creating detailed tutorials with examples and projects.