Excel 2024: Text Before or After a Specific Delimiter


October 15, 2024 - by

Excel 2024: Text Before or After a Specific Delimiter

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.

continue reading »

More Reading


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

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

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

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.

read more articles »

Featured Products


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!


The Transformative Magic of Power Query M Code in Excel and Power BI

August 2024

A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution


see more products »