Text
Join, split, trim and change the case of text: names, product codes and email addresses.
Lessons
In the order the Roadmap teaches them.
In the full course. Beginner · 8 min
Combine first and last names
Join first and last names, or any text, into one cell with & or CONCAT, with the spaces and commas where you want them.
See the lessonIn the full course. Beginner · 7 min
Change case: UPPER, LOWER, PROPER
Fix capitalization with UPPER, LOWER and PROPER in a helper column, and know which names PROPER gets wrong.
See the lessonIn the full course. Beginner · 9 min
Remove extra spaces with TRIM
Find the invisible spaces that break lookups and hide duplicates, and clean them with TRIM in a helper column.
See the lessonIn the full course. Confident · 9 min
Join lists with TEXTJOIN
Join a whole row or column into one cell with a separator of your choice, and skip the empty cells, with TEXTJOIN.
See the lessonIn the full course. Confident · 10 min
Split full names into first and last
Split full names into first and last name with FIND, LEFT and MID, or in one go with the split-text tool, and know when each is right.
See the lessonIn the full course. Confident · 9 min
LEFT, RIGHT and MID
Pull the first, last or middle characters out of a code with LEFT, RIGHT and MID, counting the start position correctly.
See the lessonIn the full course. Confident · 10 min
FIND and SEARCH
Find a word inside a cell with FIND or SEARCH, know which one cares about capitals, and flag every row that mentions it with ISNUMBER.
See the lessonIn the full course. Confident · 11 min
SUBSTITUTE and REPLACE
Rewrite part of a text with SUBSTITUTE when you know what to change, or with REPLACE when you know where it is.
See the lessonIn the full course. Confident · 10 min
Count characters with LEN
Count the characters in a cell with LEN, spaces included, and use it to catch ZIP codes and names that are the wrong length.
See the lessonIn the full course. Confident · 10 min
Put numbers and dates inside text with TEXT
Write sentences that include amounts, dates and percentages formatted the way you want, with & and TEXT.
See the lessonIn the full course. Confident · 9 min
Extract the domain from an email address
Pull the domain out of any email address with MID and FIND (or TEXTAFTER in Excel), and see which companies a list comes from.
See the lessonIn the full course. Confident · 8 min
Split text with SPLIT
Split text into cells with one SPLIT formula, and keep each piece whole when the delimiter is more than one character.
See the lessonIn the full course. Advanced · 10 min
Pattern matching with regular expressions
Use a pattern to check text, pull out the part you want and swap parts of it, so one formula cleans up messy entries.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Clean up messy data
For exports, CSVs and form responses that need tidying before anyone can use them.
10 lessons · about 1 h 30 min · 1 free · Beginner to Confident
See the pathGoogle Sheets basics in a weekend
For starting from zero, or only typing numbers into cells today.
14 lessons · about 2 h · 4 free · Beginner to Confident
See the pathGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.