Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Compare upper, lower, proper and preserved text

Your goal: Compare three capitalization methods beside the untouched source, reveal case-sensitive changes and choose a policy explicitly.

Full task requirements

Fill C2:G5 as twenty separate formulas. C uses UPPER, D LOWER and E PROPER on the same original row. F compares the original to E using EXACT. G uses CHOOSE and numeric B7: 1 selects C, 2 D, 3 E and 4 the untouched original B value. B2:B5 must be nonempty printable ASCII text up to 40 characters, including spaces, punctuation and numeric-looking spelling. Preserve all spaces and characters outside letter case. B7 is a numeric whole policy index 1..4. This bounded mechanical case comparison is not a name-correction service, title-style guide or multilingual capitalization certification.

Compare acronym, apostrophe, digit and mixed-name policiesUPPER for source row 20 cells selected
Quoted spellings preserve original spaces and punctuation. Checked case helpers keep their worksheet coordinates.
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
Step 1 of 20

UPPER for source row 2

Select the source cells in the worksheet, then complete the choices below.

Rules for this step

Select the original text, preserve every space and punctuation mark, and apply the stated mechanical case policy. PROPER capitalizes a letter after any nonletter; it is not a name-correction rule.

Your result in C2
0 cells selected