Add accents (AI)
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Text ops
Command ID: btnAddAccents
What it does
The command sends the content of each selected cell to the AI (Gemini), asks for it back as fully accented Vietnamese, and writes the answer over the original cell. It rescues tables typed without diacritics: hurried site diaries, worker lists exported from a time-clock, abbreviated material names.
The result is the model's contextual guess. It is usually very good on ordinary Vietnamese sentences, but proper names, product codes and technical jargon should always be reviewed.
How to use
- Select the cells holding unaccented text.
- Go to tab DVD Addin → group Text and Number → menu Text ops → Add accents (AI).
- The status bar shows "Adding Vietnamese accents to N cells via Gemini…". The work runs in the background, so Excel stays usable.
- Cells are updated one by one. When the run finishes, the status bar reports the total number of cells accented.
- If the selection contains no text cells, the command reports "No cell contains data".
Example
A site diary typed quickly on a phone by the field engineer, with the whole column unaccented. Select the activity column and run the command.
| Before | After |
|---|---|
| do be tong dam san tang 3 | đổ bê tông dầm sàn tầng 3 |
| nghiem thu cot thep truoc khi do | nghiệm thu cốt thép trước khi đổ |
| tap ket vat tu gach xay tuong | tập kết vật tư gạch xây tường |
Afterwards, scan the rows containing personal names or contractor names to be sure the AI did not guess wrong.
Notes
- Requires an internet connection and a configured Gemini API key for the add-in; without either, the cells stay unchanged.
- Each cell is a separate AI call, so a few hundred cells takes a long time and consumes quota. Work in smaller blocks.
- Results overwrite the original cells and Ctrl+Z cannot undo this — copy the source data to a helper column first.
- Cells the AI cannot answer for keep their original content, with no per-cell error message.
- The model can misread proper names, material codes and abbreviations, so review before the sheet goes into a signed record.
Related
- Remove accents — the reverse operation, stripping Vietnamese diacritics.
- Grammar — AI spelling and grammar fixes for the selected range.
- Translate — translate cell content into another language.
- Smart Data Cleaning… — normalise casing once the accents are back.