Data Cleaning: Split Codes, Fix Case, Convert Text to Numbers
This lesson is part of the course
In this lesson
You clean a CRM export: split product codes, fix case and spaces, turn "$1,240.50" text into numbers and expose a duplicate.
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
- Entering Data & Your First Formulas Locked
- Relative, Absolute & Mixed References Locked
- Math & Stats Functions: SUM, AVERAGE, COUNT, MEDIAN Locked
- Logical Functions: IF, AND, OR, IFS, IFERROR Locked
- Lookups: VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP Locked
- Text Functions: LEFT, MID, TRIM, PROPER, TEXT & Joining Locked
- Date Functions: DATE, EDATE, EOMONTH, NETWORKDAYS Locked
- SUMIFS, COUNTIFS & AVERAGEIFS Locked
- Data Cleaning: Split Codes, Fix Case, Convert Text to Numbers Locked
- Final Project: Monthly Sales Report Locked