Power Query practice: Text Cleansing & Standardization
Chapter 5 · 5 questions · included in full access
Question 1 · easy
Trim stray spaces
Solve it in your browserRemove the leading and trailing spaces in Customer. Select it, then Transform ▸ Format ▸ Trim.
Question 2 · medium
Proper names
Solve it in your browserMake Customer tidy: trim it, then Capitalize Each Word (" sharma traders " → "Sharma Traders").
Question 3 · medium
Consistent product names
Solve it in your browserProduct names arrive in every possible case. Trim them and make them UPPERCASE.
Question 4 · medium
Digits-only phone numbers
Solve it in your browserClean Phone so it holds digits only: replace every
-with nothing, then every space with nothing. Use Home ▸ Replace Values twice.Question 5 · easy
Trim versus Clean
Solve it in your browserWhat is the difference between
Text.TrimandText.Cleanin Power Query?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing