Splitting Full Names, Emails and Addresses
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
- 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