Hi - Dave here.
Happy Friday!
This week, I have a new video that shows how you can use the TEXTAFTER function together with the TEXTBEFORE function.
This might seem like a strange idea, but this approach is quite useful when you need to extract a value
between other values.
The video below explains how it works with two examples:
Click to watch a brief demo - 4 minutes
This video is part of our course on
Dynamic Array Formulas, which covers new functions and behaviors in the Excel formula engine. These new tools can drastically simplify many challenging problems in Excel. If you already own the Dynamic Array course, you'll find this new video in the Text Functions section of the course.
Note: TEXTAFTER and TEXTBEFORE are new functions in Excel and are only available in Excel 365 or Excel 2021.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
