Excel Text Functions: LEFT, MID, FIND, SUBSTITUTE & Clean Data
LEFT, RIGHT, LEN, FIND vs SEARCH, MID between delimiters, SUBSTITUTE and REPLACE, TRIM and PROPER, TEXTJOIN, TEXT formats and name, email and code splitting in 8 hands-on labs at one shop, every cell checked instantly.
The first lesson is free — no account needed.
About this course
An Excel text functions course that cleans and splits the messy data of one fictional online shop for home textiles and kitchenware, for anyone who copies text into cells by hand. You cut fixed-width order IDs apart with LEFT, RIGHT and LEN, extract the colour and size between two delimiters with FIND, SEARCH and MID and see why the two can disagree, swap separators and target the nth or last hyphen with SUBSTITUTE and REPLACE, tidy names, emails and promo codes with TRIM, CLEAN, PROPER and LOWER, build shipping labels with &, CONCAT and TEXTJOIN, restore leading zeros and format labels with TEXT, split full names, email domains and addresses with formulas that update with the list, and parse product codes into a category count and chart. The first lab is free.
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