SheetsdrillTidy up pasted names
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Names were pasted with extra spaces and random capitals. Clean them up: no leading or trailing spaces, single spaces between words, and the first letter of each word in capitals. Fill B2 and B3 using TRIM and PROPER.
What this exercise teaches
Stray spaces are invisible but break lookups and COUNTIF, because "Lee " is not "Lee". TRIM first, then PROPER, is the standard cleanup before a name column is used as a key.
A hint if you get stuck
TRIM removes the leading and trailing spaces and collapses runs of spaces to one. PROPER capitalizes the first letter of every word. Nest one inside the other.
Try it now, free, no account needed
The first 15 tasks on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Text and dates
- First name with SPLITPro
- Join the confirmed namesPro
- Address without gapsPro
- Valid order IDsPro
- Pull out the invoice numberPro
- Digits onlyPro
- Month label with TEXTPro
- Full years of servicePro
- Working days with holidaysPro
- Due at the end of next monthPro
- Items in a comma listPro
- Domain of an email addressPro
- Renewal date with EDATEPro
- Orders placed at the weekendPro
- Amount inside a sentencePro