REGEXREPLACE: Normalise Phone Numbers, IDs and Names
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
- REGEXTEST: Validate Emails, Postcodes and SKUs Before ImportFree
- REGEXEXTRACT: Pull Order Numbers out of Free-Text Notes Pro
- Every Match and Capture Groups: return_mode 1 and 2 Pro
- REGEXREPLACE: Normalise Phone Numbers, IDs and Names Pro
- Parse Web-Shop Log Lines into Columns Pro
- Redact Personal Data Before Sharing a Report Pro
- Classify Support Tickets with Patterns and Flags Pro
- Capstone: Clean a Messy Order Export End to End Pro