SMART case (AI)

Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Case

Command ID: btnSMARTCase

What it does

Sends the content of each selected cell to the configured AI service to fix capitalization in context, then writes the answer back into the cell. The model is instructed to change nothing but letter case: proper nouns, company names, places and sentence starts are capitalized, while wording and grammar stay exactly as written.

This solves the weakness of Proper Case and Sentence case, which flatten acronyms and names. SMART case keeps TCVN, RC, PMU, a company name and a person's name intact inside the same line.

How to use

1. Configure the AI service in Preferences (Gemini / OpenAI / Groq / NVIDIA) together with its API key.
2. Select the text cells whose capitalization needs fixing.
3. Go to tab DVD Addin → group Text and Number → open the Case menu → click SMART case (AI), or press Ctrl+Shift+S.
4. The command works asynchronously, area by area, so Excel does not freeze while waiting on the network.
5. Each cell is updated as its answer arrives; cells the service fails on keep their original text.

Example

The description column of an acceptance record, typed without regard to case:

Before	After
inspection of beam and slab rebar to tcvn 5574:2018	Inspection of beam and slab rebar to TCVN 5574:2018
contractor: hoang long construction jsc	Contractor: Hoang Long Construction JSC
supervisor: engineer nguyen van an	Supervisor: Engineer Nguyen Van An

Notes

• An internet connection and a valid API key are required; without them the cells are simply left unchanged, with no per-cell warning.
• Formula cells and empty cells are skipped — only cells holding text are sent.
• A large selection means many API calls and can hit the provider's rate limit, so work in batches of a few dozen cells.
• Cell content leaves your machine for an external AI service; do not use it on confidential project data.
• Results overwrite the cells directly and cannot be fully undone with Ctrl+Z — keep a copy before running it on an original record.

Related

• Proper Case — the offline alternative, at the cost of broken acronyms.
• Sentence case — rule-based normalization with no AI call.
• AI Chat — the hub for the add-in's other AI commands.
• Preferences — where the AI service and API key for this command are set.