Splitting Full Names, Emails and Addresses
This lesson is part of the course
In this lesson
You split Pinewick's customer list into first name, last name (also with middle names), email domain and state, with formulas that update when the list changes.
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