Text Formulas: FIND, MID, SUBSTITUTE, TEXT and TEXTJOIN
This lesson is part of the course
In this lesson
You pull the weight out of a messy export, count tags, build price labels with proper formatting and list every SKU under a price limit in one cell.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Advanced Lookups: Two-Way, Multi-Criteria and Tiers Locked
- Multi-Criteria SUMIFS, COUNTIFS, AVERAGEIFS and MAXIFS Locked
- SUMPRODUCT with Boolean Arrays Locked
- Array Math inside SUM, AVERAGE, MAX and MATCH Locked
- Nested Logic: IFS, SWITCH, CHOOSE and IFERROR Locked
- Text Formulas: FIND, MID, SUBSTITUTE, TEXT and TEXTJOIN Locked
- Date & Time Formulas: EOMONTH, NETWORKDAYS, WEEKNUM, HOUR Locked
- Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN Locked
- Financial Formulas: PMT, PPMT, NPV and XNPV Locked
- Capstone: Audit and Repair a Broken Report Locked