Remove accents

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

Command ID: btnRemoveAccents

What it does

The command strips every Vietnamese diacritic from the selected cells: Đường becomes Duong, Bê tông cốt thép becomes Be tong cot thep. The letters đ and Đ are converted to d and D as well.

You need this when exporting to legacy management software that cannot handle Unicode, when naming document folders after work packages, or when building an accent-free lookup key so matching stays reliable.

How to use

1. Select the cells containing accented text.
2. Go to tab DVD Addin → group Text and Number → menu Text ops → Remove accents.
3. It runs immediately, with no dialog. The status bar reports how many cells were stripped.
4. If nothing is selected, the command shows "Please select a data range" and stops.

Example

A work-package list used to create the folder names for acceptance records on the shared server.

Before	After
Móng đơn trục A-1	Mong don truc A-1
Bê tông cốt thép dầm sàn tầng 2	Be tong cot thep dam san tang 2
Đường ống cấp nước D110	Duong ong cap nuoc D110

The result column can be used directly as folder names or exported PDF file names.

Notes

• Ctrl+Z cannot undo this — copy the accented text to a helper column first if you want to keep it.
• Only text cells are affected; numbers, dates and blanks stay as they are.
• A formula returning text is overwritten with its static, accent-free value.
• Stripping accents is lossy: Hòa, Hoa and Họa all collapse to Hoa, so do not use the stripped column as a unique key when collisions are likely.
• To restore accents, use Add accents (AI), but bear in mind the result is an AI guess, not a guarantee.

Related

• Add accents (AI) — the reverse operation, restoring Vietnamese diacritics with AI.
• UnDiacritics Folder — strips accents from file names instead of cell values.
• UnDiacritics — strips accents from the sheet names in the workbook.
• Encoding — use this instead when the text displays wrongly due to a legacy Vietnamese font.