LEFT, RIGHT & LEN: Fixed-Width Codes
All lessons
- LEFT, RIGHT & LEN: Fixed-Width CodesFree
- FIND vs SEARCH and MID: Extract Text Between Delimiters Pro
- SUBSTITUTE & REPLACE: Swap Text and Target the nth Occurrence Pro
- TRIM, CLEAN, PROPER, UPPER & LOWER: Tidy Customer Data Pro
- Joining Text: &, CONCAT and TEXTJOIN Pro
- TEXT and Number Formats: Labels, IDs and Leading Zeros Pro
- Splitting Full Names, Emails and Addresses Pro
- Capstone: Parse Product Codes and Chart Counts by Category Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Loading the spreadsheet…