Cities in one format

Sales reps typed city names any which way: with extra spaces, in lowercase and in uppercase. Because of this, the report by city falls apart.

Bring the names in B2:B9 to one format: no extra spaces and a capital letter at the start of each word, for example “New York”.