TRIM, PROPER and UPPER practice exercises
Tidy up text that came from somewhere else: strip extra spaces, and fix names and codes typed in the wrong case.
- 1Remove extra spaces with TRIMIn B2, use TRIM to remove the extra spaces from the name in A2.
- 2Fix the case of names with PROPERPremiumIn B2, use PROPER to write the name in A2 with a capital first letter in each word.
- 3Clean a code with UPPER and TRIMPremiumIn B2, clean up the code in A2 so it has no extra spaces and is all capitals. Put TRIM inside UPPER.
- 4Fix messy names with PROPER and TRIMPremiumThe name in A2 has extra spaces and the wrong capitals. In B2, clean it up to "Maria Lopez". Put TRIM inside PROPER.