Task 1 of 3
In D2:D5, tidy up the names: no extra spaces, and each word capitalized.
Lesson theory
Data from forms and exports is almost always messy: extra spaces, inconsistent capitalization, parentheses in phone numbers.
TRIMremoves spaces at the edges and doubled spaces inside;PROPERcapitalizes The First Letter Of Each Word;SUBSTITUTE(text, "old", "new")replaces text. You can nest several of them;TEXTJOIN(", ", TRUE, range)joins a list with commas and skips the empty cells.
=PROPER(TRIM(A2)) turns " adam parker " into "Adam Parker"Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.