Proper Case
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Case
Command ID: btnProperCase
What it does
Lowercases the text in the selection and then capitalizes the first letter of each word (Title Case) — the equivalent of Excel's PROPER function, but applied directly to the cells so no helper column is needed.
This is the right style for people's names, company names and short item titles in a manpower allocation sheet, an engineering staff list or a subcontractor tracker, where entries are usually typed with mixed capitalization.
How to use
- Select the cells you want normalized.
- Go to tab DVD Addin → group Text and Number → open the Case menu → click Proper Case.
- The command runs immediately — no dialog appears.
- The Excel status bar reports "Changed N/M cells". If nothing changed, a message box explains why.
Example
The name column of a site manpower timesheet:
| Before | After |
|---|---|
| nguyen van an | Nguyen Van An |
| TRAN THI BINH | Tran Thi Binh |
| le hoang NAM | Le Hoang Nam |
| hoang long construction jsc | Hoang Long Construction Jsc |
Notes
- Because the text is lowercased first, acronyms are broken: JSC becomes Jsc, TCVN becomes Tcvn, RC becomes Rc — fix them by hand or use SMART case (AI).
- Formula cells are preserved — they are never overwritten with their values.
- Hold ESC while it runs to stop early; areas already written stay written.
- The selection is clamped to the UsedRange so whole-column selections are still fast, and empty cells are skipped.
- Content is overwritten in place; Ctrl+Z may not restore the entire range.
Related
- SMART case (AI) — keeps the acronyms and proper nouns that Proper Case flattens.
- Sentence case — better suited to full sentences than to names.
- UPPERCASE — for table titles and top-level item names.
- lowercase — the flattening step before re-normalizing.