Splitting Codes & Names: LEFT, MID, FIND
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Trimming Spaces & Fixing Case: TRIM, PROPER, UPPERFree
- Splitting Codes & Names: LEFT, MID, FIND Pro
- Converting Text Numbers & Text Dates into Real Values Pro
- Standardising Categories with a Mapping Table (XLOOKUP) Pro
- Finding Duplicates & First Occurrences with COUNTIFS Pro
- Handling Blanks & Outliers: IF, MEDIAN and Flags Pro
- Validating Rows: Rule Checks with AND, OR and an Error Count Pro
- Capstone: an Analysis-Ready Table and a Region × Month Summary Pro