Amazing Feature: 14 New TEXT functions

14 New TEXT Functions

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.

Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.