UPPERCASE
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Case
Command ID: btnUPPERCASE
What it does
Converts every text character in the selection to capitals, handling Vietnamese diacritics correctly through the current system culture. Values are read and written one contiguous area at a time, so it stays fast on tables of several thousand rows.
In construction paperwork, full capitals are the convention for table titles, top-level item names, package names and the heading line of an acceptance record — anywhere the document template demands all-caps.
How to use
- Select the cells you want converted.
- Go to tab DVD Addin → group Text and Number → open the Case menu → click UPPERCASE.
- 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 heading block of a work acceptance record:
| Before | After |
|---|---|
| Work acceptance record | WORK ACCEPTANCE RECORD |
| Column concrete works, level 3 | COLUMN CONCRETE WORKS, LEVEL 3 |
| Employer: Project Management Unit No. 2 | EMPLOYER: PROJECT MANAGEMENT UNIT NO. 2 |
Notes
- Formula cells are preserved — their results are never frozen into static values.
- Numbers and dates come out unchanged, since the uppercase form of a digit is the digit itself.
- 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
- lowercase — the opposite conversion.
- Proper Case — capitalizes only the first letter of each word.
- Sentence case — normalizes long text sentence by sentence.
- SMART case (AI) — lets AI pick the capitalization that fits the context.