WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
Fourteen new functions coming to Excel
Part one of a three-part series of blogs

Get a preview of the 3 text functions and 11 array functions coming to your version of Excel very soon!

  1. Fourteen new functions coming to Excel (this blog)
  2. New text functions (TEXTBEFORE, TEXTAFTER, TEXTSPLIT)
  3. New functions for array manipulation

Posted by Andy Brown on 20 April 2022

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Fourteen new functions coming to Excel

It's not that often Excel gets any new functions, but 14?  Truly these are momentous times.  Here's a quick summary of the new functions (as covered in the other parts of this blog):

Family Notes
Splitting text TEXTBEFORE, TEXTAFTER and TEXTSPLIT
Combining arrays HSTACK and VSTACK
Reshaping arrays TOROW, TOCOL, WRAPROWS and WRAPCOLS
Resizing arrays TAKE, DROP, CHOOSEROWS, CHOOSECOLS and EXPAND

If you've worked with arrays in NumPy using Python, you'll know where Microsoft got the idea for all of the array functions shown above!

When will I get these new features?

Microsoft roll out new Office 365 updates at different times to different users, but you can get an idea of your place in the pecking order by seeing what channel you're on.

File Account in Excel

Choose the Account option from the File menu in Excel to see which channel you're using.

 

I've bravely upgraded my laptop to the beta channel, which is why I can see the new features (even then I had to do a bit of coaxing to get them to install):

About MS Excel

The About Excel button shows that I'm on the Beta Channel.  Chances are that you will be either on the monthly channel (in which case you'll get updates soon after they go on general release) or the semi-annual channel (in which case you may wait up to 6 months).

It's always worth clicking on the drop arrow on the Update Options button above to check that you have the latest update installed!

This blog has 0 threads Add post