Trimming Spaces & Fixing Case: TRIM, PROPER, UPPER
This lesson is part of the course
In this lesson
You clean a CRM export with stray spaces and mixed case, then prove that the cleaning changes the analysis.
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
- Trimming Spaces & Fixing Case: TRIM, PROPER, UPPER Locked
- Splitting Codes & Names: LEFT, MID, FIND Locked
- Converting Text Numbers & Text Dates into Real Values Locked
- Standardising Categories with a Mapping Table (XLOOKUP) Locked
- Finding Duplicates & First Occurrences with COUNTIFS Locked
- Handling Blanks & Outliers: IF, MEDIAN and Flags Locked
- Validating Rows: Rule Checks with AND, OR and an Error Count Locked
- Capstone: an Analysis-Ready Table and a Region × Month Summary Locked