Excel Regex Text Extraction: REGEXTEST, REGEXEXTRACT & REGEXREPLACE
Validate emails, postcodes and SKUs with REGEXTEST, pull order numbers, amounts and dates out of free text with REGEXEXTRACT and its return modes, normalise phone numbers and names with REGEXREPLACE, parse log lines, redact personal data, classify tickets with flags and clean a messy export: 8 hands-on labs, graded instantly.
The first lesson is free — no account needed.
Lessons
- 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