Google Sheets functions
Pick a function to see how it works, with a worked example on real data. The Basics drills are free, and Pro unlocks the rest, along with a real-world scenario for every section and five closing projects.
Getting started
8 lessonsFreeBasics
10 lessonsFreeConditions
9 lessons ProLookups
6 lessons ProText
12 lessons Pro- TRIMRemove extra spaces
- PROPERFix capitalisation
- LEFTTake the first characters
- MIDTake characters from the middle
- LENCount characters
- & (join)Join text together
- SUBSTITUTEReplace text
- SPLITSplit text into columns
- REGEXMATCHTest for a pattern
- REGEXEXTRACTPull out a pattern
- JOINJoin a whole column
- ScenarioClean a contact list for a mail merge