Sentence case
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Case
Command ID: btnSentencecase
What it does
Lowercases all text in the selection, then capitalizes the first letter of each sentence. Before converting, it also tidies whitespace: leading and trailing spaces are trimmed and runs of consecutive spaces are collapsed to one.
This is what you reach for when data arrives typed inconsistently — work descriptions in a bill of quantities, inspection remarks, site diary entries — and it has to look uniform before the file is printed into a record.
How to use
- Select the text cells you want normalized.
- Go to tab DVD Addin → group Text and Number → open the Case menu → click Sentence case.
- The command processes each contiguous area in one pass — no dialog appears.
- The Excel status bar reports "Changed N/M cells". If nothing changed, a message box explains why (all formulas, all empty, or already in the right format).
A letter is capitalized when it starts the string or follows one of the pairs . , : , ? , ! , / , - .
Example
A work-description column received from a subcontractor:
| Before | After |
|---|---|
| pour COLUMN concrete level 3. inspect before pouring | Pour column concrete level 3. Inspect before pouring |
| ERECT beam and slab formwork | Erect beam and slab formwork |
| note: check the setting-out level | Note: Check the setting-out level |
Notes
- Formula cells are preserved — they are never overwritten with their values.
- Proper nouns and acronyms such as TCVN, RC or PM are lowercased — use SMART case (AI) when the text is full of names.
- Hold ESC while it runs to stop early; areas already written stay written.
- The selection is clamped to the UsedRange, so selecting whole columns is still fast.
- The command overwrites cell content and cannot be fully undone with Ctrl+Z; a detailed log is kept at
%TEMP%\DVDAddin\case.log.
Related
- UPPERCASE — converts the whole selection to capitals.
- Proper Case — capitalizes the first letter of every word.
- SMART case (AI) — uses AI so proper nouns and acronyms survive.
- Remove extra spaces — cleans whitespace without touching letter case.