TEXT and Number Formats: Labels, IDs and Leading Zeros
This lesson is part of the course
In this lesson
You turn Pinewick's invoice numbers into padded IDs, restore the lost leading zeros of ZIP codes and build readable labels with dates and dollar amounts.
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
- LEFT, RIGHT & LEN: Fixed-Width Codes Locked
- FIND vs SEARCH and MID: Extract Text Between Delimiters Locked
- SUBSTITUTE & REPLACE: Swap Text and Target the nth Occurrence Locked
- TRIM, CLEAN, PROPER, UPPER & LOWER: Tidy Customer Data Locked
- Joining Text: &, CONCAT and TEXTJOIN Locked
- TEXT and Number Formats: Labels, IDs and Leading Zeros Locked
- Splitting Full Names, Emails and Addresses Locked
- Capstone: Parse Product Codes and Chart Counts by Category Locked