Top 2022 blog posts on Excel’s new formulas

  • Technology and AI

Excel’s latest version comes with some exciting new features and enhancements.

In this blog, we’ll get to know six new Excel formulas that will help you save time in Excel, along with some useful resources to master them. From XLOOKUP to the brand-new text and array formulas, this page will give you the tools to improve your everyday life in Excel.

TEXTSPLIT

New Excel formulas 2022: TEXTSPLIT

TEXTJOIN has been around for a little while as a text-combining formula… but have you met TEXTJOIN’s new counterpart: TEXTSPLIT?

TEXTSPLIT allows you to split text into multiple columns/rows. Like TEXTJOIN, this new Excel feature uses a given delimiter (i.e. space or comma) to separate the text over the desired cells.

Get familiar with TEXTSPLIT with this helpful content:

TEXTBEFORE and TEXTAFTER

New Excel formulas 2022: TEXTBEFORE


TEXTBEFORE and TEXTAFTER are great tools if you want to extract text from the start or end of a cell. TEXTBEFORE pulls out all text that comes before a given delimiter, while TEXTAFTER does the same with text after that delimiter.

Learn how to leverage these new Excel formulas with these short blogs below:

TAKE and DROP

New Excel formulas 2022: TAKE


These new Excel features allow you to keep (TAKE) or remove (DROP) a given number of columns/rows from the start or end of an array.

CHOOSECOLS and CHOOSEROWS

New Excel formulas 2022: CHOOSECOLS


These brand new Excel formulas are an easy way of extracting specific columns (CHOOSECOLS) or rows (CHOOSEROWS) from a range of datasets, whether they’re non-contiguous or right next to each other.

Check out these links to get to grips with CHOOSECOLS and CHOOSEROWS:

VSTACK and HSTACK

New Excel formulas 2022: VSTACK


VSTACK and HSTACK allow you to combine two or more sets of arrays vertically (VSTACK) or horizontally (HSTACK). Better yet, these new Excel functions even work with dynamic arrays and ranges with large source sizes!

XLOOKUP

New Excel formulas 2022: XLOOKUP


If you’re an Excel aficionado, you must know the XLOOKUP formula. It’s been available in Office365 and Excel for web since 2020, but we still can’t get enough of this feature in 2022! XLOOKUP is a powerful look-up function that can go far beyond the limitations of VLOOKUP and the INDEX and MATCH functions.

Interested in learning more? Check out these articles below:


BONUS: Top Excel formulas videos 2022

If you prefer a video tutorial, we’ve also attached our favourite guide to new Excel formulas in 2022 here:

This video is an informative and concise overview of the functions we’ve just covered. Thanks to Mike Tholfsen, you can get to grips with these new Excel functions in just 5 minutes.

What’s your favourite new Excel function? Tell us in the comments below!

Tariq Sinnetamby Tariq is a Content Specialist at UpSlide. A branding enthusiast with a keen interest in emerging technologies, Tariq sits within our Marketing team. He also has over 2+ years of marketing experience across the online food delivery, travel, and technology sectors.
Subscribe
Notify of
guest
22 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Excel Classes in Pune
3 years ago

Thanks for sharing such a useful information. Having some training in Excel is a MUST nowadays.As a professional in your field, you already know the benefits of using Microsoft Excel. By using Excel, you’ll save a ton of time at your job and/or in your personal life, and it’s guaranteed to be more accurate than something you could’ve done by hand. Get the Best Microsoft Advanced Excel classes in pune only on urbanpro platform.

Edouard Ouaknine
Admin
3 years ago

Thank you Vanessa! Nice to meet another Excel enthusiast truly convinced by its utility 🙂
We suggest you discover Power Query and Power BI with our sister company https://www.finance3point1.com/en/ , expert in data modeling.

LAST
3 years ago

Thanks Bro, I gain Much More KNowledge in this post such a Great Job Related Post

ghar pe shiksha
3 years ago

excel is a good kind of software for professionals. it saves time and human efforts. it sorts out many kinds of complex problems in few seconds. preparing work report is very import for saving and managing data. i always use excel for managing data.

Private Tutors
2 years ago

I am so grateful for your blog.i Really looking forward to read more! Really Great.

Online Thesis Help
2 years ago

Thank you so much for sharing this blog! I just want to mention I am just new to blogging and really enjoyed you’re web blog. Most likely I’m want to bookmark your blog post . You certainly have awesome articles.

Online Essay Help
2 years ago

Thank you so much for sharing this blog! I just want to mention I am just new to blogging and really enjoyed you’re web blog. Most likely I’m want to bookmark your blog post .

Regards,

informix training
2 years ago

Thank you for excellent article. You made an article that is interesting.

cloud computing training

Excellent post with valuable content. It is very helpful for me and a good post.

Last edited 2 years ago by cloud computing training
Titus Bettis
2 years ago

Cool!

Last edited 2 years ago by Titus Bettis
James Beam
2 years ago

Thanks for the great article. The fact is that for the new functions to work, we had to change the way Excel works. Before the advent of Dynamic Array Functions (DAF), the user essentially could not reference a range of cells in one cell. Rather, he could have referred, but, let’s say, such links worked in very limited cases. However, in fairness, it should be noted that everything started with array formulas, it just evolved in DAF, which can be indirectly judged from Microsoft’s messages that array formulas will be left in Excel for compatibility. By the way, you can… Read more »

SARIKONDA SHIVA KUMAR
2 years ago

The content is amazing, i really liked it 
thankyou

sactpro
2 years ago

Best article ever read like this till now, Thankyou, the article is very good and i learned many things
please post more like this thankyou

santanu
2 years ago

There is so many software but excel is one of the best. One needs to know the right command. When used excel can do a lot of tasks. Thanks for sharing

Last edited 2 years ago by santanu
Spreadsheet Daddy
2 years ago

Thanks for the roundup!

Chandan Singh
1 year ago

We are very grateful to you for this information and we hope that you will continue to give us such information.

manoj
manoj
1 year ago

Thank you, for this information 
The blog is very informative. looking forward to reading more from you thank you

preeti pathak
1 year ago

nice article

DG ROYAL
1 year ago

All I can say is wow keep up the great work .Your effort is deeply, deeply appreciated.nice ideas

Excel
1 year ago

There is so many software but excel is one of the best. One needs to know the right command. When used excel can do a lot of tasks. Thanks for sharing

e-Tuitions
1 year ago

import from the web is a great formula in excel also the formula you have explained are awesome these formulas make our work easy. thanks for sharing

Assignment Help
9 months ago

Thanks for sharing. Nice blog. 

Want to see more?

See more
Finance insights
5 minutes

AI in finance: insights from a B2B SaaS CEO

In the past few months, we’ve seen growing excitement around AI and its potential to reinvent the way we work.
Technology and AI
5 minutes

Our take on Microsoft Build 2023

This year’s Microsoft Build was arguably one of the most awaited to date. Just a short few months after the announcement...
Finance insights
8 minutes

Will Microsoft Copilot reinvent the future of work in finance? 

The Artificial Intelligence (AI) arms race is truly heating up. As tech giants go all in on this revolutionary...