lowercase
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Case
Command ID: btnlowercase
What it does
Converts every text character in the selection to lowercase, 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 large tables.
It is often an intermediate step: data arrives typed entirely in capitals, you flatten it to lowercase and then run Sentence case or Proper Case for a clean result. Lowercase is also what you want for material codes, file paths and email addresses in a project contact list.
How to use
- Select the cells you want converted.
- Go to tab DVD Addin → group Text and Number → open the Case menu → click lowercase.
- 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
A contact list received from a contractor with inconsistent capitalization:
| Before | After |
|---|---|
| ENGINEERING@Contractor-ABC.VN | engineering@contractor-abc.vn |
| Supervisor.A@Consultant-XYZ.COM | supervisor.a@consultant-xyz.com |
| PROCUREMENT@ReadyMix-Co.vn | procurement@readymix-co.vn |
Notes
- Formula cells are preserved — they are never overwritten with their values.
- Numbers and dates come out unchanged, since the lowercase 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
- UPPERCASE — the opposite conversion.
- Sentence case — the natural next step after flattening to lowercase.
- Proper Case — capitalizes each word for names and item titles.
- Remove accents — strips Vietnamese diacritics for codes and file names.