In Sheets, type the helper-column formula that removes stray spaces from A2 and folds it to capitals.

Answer

=UPPER(TRIM(A2))

Inside out: TRIM first, then UPPER. "on " → "ON", " Qc" → "QC". Recoding "Ontario" to "ON" needs a lookup (Lesson 6.8).