Module 3 · You are here
Splitting Concatenated Fields
Turn one messy cell into the four or seven clean cells you actually need. Names get split into First and Last. Addresses get split into Street, City, State, and ZIP.
By the end of Module 3, you will be able to:
- Diagnose when a column should have been multiple columns.
- Use Text to Columns with delimiter and fixed-width options.
- Use =SPLIT(A1, ",") for live, formula-based splitting.
- Use LEFT, MID, RIGHT, and FIND to surgically extract pieces.
- Handle edge cases: middle names, suite numbers, missing commas.
Subsections in Module 3
3.1
When one cell should have been four
Open 3.2Text to Columns vs SPLIT
Open 3.3Hands-on: split the address
Open 3.4LEFT, MID, RIGHT, FIND for surgical extraction
Open 3.5Field-splitting checkpoint
OpenStart here: Module 3.1 · When one cell should have been four
Begin Module 3
After Module 3: Module 4 · Placeholders, Junk, and Standardization
Next: Module 4 · Placeholders, Junk, and Standardization