Excel 2024: Text Before or After a Specific Delimiter

October 15, 2024 - by Bill Jelen

The new TEXTBEFORE and TEXTAFTER functions debuted on March 16, 2022 for Microsoft 365 Insiders. These functions isolate the text before or after a specific delimiter.

The function syntax requires some text and the delimiter. Optional arguments: instance_num for which delimiter, match_mode for case sensitive, match_end prevents an #N/A if the delimiter is not found. TEXTBEFORE("Cher"," ") returns #N/A. =TEXTBEFORE("Cher"," ",,,1) returns Cher.

More Reading

Excel 2024: Find Largest Value That Meets One or More Criteria »

October 11, 2024 - by Bill Jelen

One of the new Office 365 functions added in February 2016 is the MAXIFS function. This function, which is similar to SUMIFS, finds the largest value that meets one or more criteria: You can either hard-code the criterion as in row 7 below or point to cells as in row 9. A similar MINIFS function finds the smallest value that meets one or more criteria.

Excel 2024: New LAMBDA Helper Functions »

October 9, 2024 - by Bill Jelen

About a year after LAMBDA was introduced, Microsoft realized that we needed some helper functions. They gave us MAP, REDUCE, SCAN, MAKEARRAY, BYROW, BYCOL, and ISOMITTED.

Excel 2024: Combining Subformulas into a Single Lambda »

October 7, 2024 - by Bill Jelen

Often, I will need a complicated formula. It is easier to build that formula in tiny steps. Once the subformulas are working, you can try to combine everything into one complicated formula.

Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Programming PowerPoint with VBA

February 2022

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.

Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.

see more products »

Excel 2024: Text Before or After a Specific Delimiter

More Reading

Featured Products