Pro lesson · 6 exercises · first one free
Pulling text apart: LEFT, RIGHT, MID, LEN, FIND
Extract parts of codes, names and e-mails.
Functions you'll practice
- LEFT
- RIGHT
- MID
- LEN
- FIND
- TEXTAFTER
- TEXTBEFORE
How the lesson works
6 short exercises in a live spreadsheet: you type each formula yourself. Every answer is checked instantly, with hints when you're stuck.
The lesson starts with
LEFT(text, n) returns the first n characters. RIGHT returns the last n.Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 6, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.