In practice: cleaning up data
ExpertExpert
10 questions, about 22 minutes
Turn a messy export into a usable list, a job you'll definitely get at work.
What we'll do
- Combining text functions
- Turning text into a number
What you'll use
TRIMTEXTAFTERTEXTBEFOREVALUEPROPER
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself