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
TEXTAFTER: Learn More ► https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4
TEXTSPLIT: Learn More ► https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
Array manipulation Functions
These can be divided into combining arrays, Shaping Arrays or Resizing Arrays:
VSTACK / HSTACK
VSTACK: Learn More ► https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c
HSTACK: Learn More ► https://support.microsoft.com/en-us/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2
TOROW / TOCOL / WRAPROWS / WRAPCOLS
TOROW: Learn More ► https://support.microsoft.com/en-us/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289
TOCOL Learn More ► https://support.microsoft.com/en-us/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed
WRAPROWS: Learn More ► https://support.microsoft.com/en-us/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0
WRAPCOLS: Learn More ► https://support.microsoft.com/en-us/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2
Availability
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.
Stay tuned.
