Excel & Sheets practice: Text Cleaning & Standardization
Chapter 12 · 3 questions · included in full access
Question 1 · easy
Clean up names
Solve it in your browserTurn each Raw Name into a clean name — no extra spaces, each word capitalised (
" rahul SHARMA "→Rahul Sharma). Start in H2, fill to H9.Question 2 · hard
Ten-digit phone numbers
Solve it in your browserPhones arrive as
98-765 43210,(91) 99887 76655,+91 94470 55443… Return the last 10 digits with every non-digit removed. Start in H2, fill to H9.Question 3 · medium
TRIM did nothing
Solve it in your browserNames pasted from a website still have a gap at the end after
=TRIM(A2). What is the most likely cause?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing