Top 2022 blog posts on Excel’s new formulas

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.

Excel formula #1: 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:

Excel formula #2: 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:

Excel formula #3: 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.

Excel formula #4: 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:

Excel formula #5: 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!

Excel formula #6: 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!

Subscribe
Notify of
guest
22 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Excel Classes in Pune
2 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.

LAST
2 years ago

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

ghar pe shiksha
2 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
1 year 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
1 year 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
1 year 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 1 year ago by cloud computing training
Titus Bettis
1 year ago

Cool!

Last edited 1 year ago by Titus Bettis
James Beam
1 year 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

The content is amazing, i really liked it 
thankyou

sactpro
1 year 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
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

Last edited 1 year ago by santanu
Spreadsheet Daddy
1 year 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
9 months ago

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

preeti pathak
7 months ago

nice article

DG ROYAL
6 months ago

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

Excel
3 months 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

IdeJalan.com
2 months ago

Great Article it its really informative and innovative keep us posted with new updates. its was really valuable.!

e-Tuitions
1 month 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

online spoken english classes
4 days ago
Awaiting for approval

Hi,
Thanks for sharing such a wonderful content. No doubt Excel is one of the best analytical tools. In fact, this is my favorite tool for creating analytical report. The reason i like it most is it has many features to maintain and represent the data in many forms.