Hi - Dave here.
Happy Friday!
It's been a while, but we are finally making some new videos again!
First up is the TEXTAFTER function, a very nice way to split text in Excel.
The video below provides an introduction to TEXTAFTER and includes three different examples:
Click to watch the video (4 minutes)
This video comes from our
Dynamic Array Formulas course. Dynamic Arrays are the biggest change to Excel's formula engine
ever. They drastically simplify complicated formulas, and provide much better tools to solve difficult problems in Excel.
If you already own the Dynamic Array course, you'll find new TEXTAFTER and TEXTBEFORE videos in the Text Functions section soon.
The new formula engine and initial group of functions (SORT, UNIQUE, etc.) are available in Excel 2021 and Excel 365. TEXTAFTER is only available in Excel 365 for now.
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
