Pro lesson · 5 exercises · first one free
Cleaning data fast: Find & Replace, Flash Fill and Text to Columns
About this lesson
The tools that fix messy imported data without writing formulas.
Text and dates · 5 short exercises in a live spreadsheet: answer questions that make you predict results or spot bugs and press the right keyboard shortcuts. Every answer is checked instantly.
What you'll practise
- Opening Find and Replace
- Filling a pattern with Flash Fill
- Splitting one column into several
- Removing duplicate rows safely
- Spotting numbers stored as text
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, 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.