Font Change

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

Command ID: btnRegularFontChange

What it does

This command changes the font of part of a cell's content, with the part identified by a delimiter. It solves a common problem in bilingual construction paperwork: the Vietnamese line and the English line live in the same cell, so you cannot set the font per cell.

Two delimiters are supported. With the in-cell line break (Chr(10)), segments 2, 4, 6… get the new font. With a slash /, the text after the slash on each line gets the new font.

How to use

1. Select the cells whose inner text needs a different font.
2. Go to tab DVD Addin → group Text and Number → menu Italic Menu → Font Change.
3. The first input box asks for the delimiter, defaulting to Chr(10). Only Chr(10) or / is accepted; anything else shows "Only Chr(10) or / separators are supported" and the command stops.
4. The second input box asks for the font name, defaulting to Times New Roman. Type the exact name of a font installed on the machine, e.g. Arial Narrow, Cambria.
5. Click OK. The matching text gets the new font, Wrap Text is switched on and the row height is auto-fitted. The status bar reports how many cells were processed.

Example

A bilingual acceptance sheet where each header cell holds two lines: Vietnamese first, English second. Select the header row, run the command, keep Chr(10) and type Arial Narrow. The "Foundation concrete" line becomes Arial Narrow, the "Bê tông móng" line keeps its original font, and the cell wraps with the row height adjusted to fit both lines.

If your sheet uses Bê tông móng / Foundation concrete on a single line instead, pick / as the delimiter and the text after the slash is restyled.

Notes

• Only the character font changes; the cell value is untouched.
• Only Chr(10) and / are valid delimiters — any other input is rejected.
• The command turns on Wrap Text and auto-fits row heights, so the table layout may shift after it runs.
• Formula cells generally do not accept per-character formatting and are skipped silently.
• For merged cells the command reads the value of the top-left cell of the merge area.
• Ctrl+Z cannot undo this.

Related

• Italic — same delimiter mechanism, applies italics instead of a font.
• Text Reverse — reorder the segments in the cell before restyling them.
• Encoding — convert the Vietnamese encoding (Unicode / VNI / TCVN3) of whole cells.
• Remove extra spaces — tidy stray spaces so the segments split cleanly.