Italic

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

Command ID: btnRegularItalic

What it does

Splits each cell's text on a delimiter you supply, then italicizes the even-numbered chunks — the text after the first delimiter, after the third, and so on in alternation. The first chunk always keeps the regular font style.

This is the standard layout for bilingual bills of quantities and for tables carrying a secondary note: the first line is the Vietnamese work description, the second line (after Alt+Enter) is the English version or an explanation, set in italic so the two read apart. Instead of selecting each fragment by hand, the command formats a whole range in one pass.

How to use

1. Select the cells you want formatted.
2. Go to tab DVD Addin → group Text and Number → click Italic, or press Ctrl+Shift+I.
3. An Excel input box asks for the delimiter, pre-filled with Chr(10), which means the in-cell line break. Keep the default or type another character such as / or -.
4. Click OK. Clicking Cancel aborts the command without changing anything.
5. The Excel status bar reports how many cells were processed.

For each cell the command first clears italic from the whole cell and then re-applies it to the alternating chunks, so running it twice gives the same result.

Example

A bilingual work-description column, each cell holding two lines separated by Alt+Enter:

• Cell A5 contains Bê tông cột M300 + line break + Column concrete M300.
• Select A5:A40, click Italic, leave the delimiter at the default Chr(10), click OK.
• Result: the Vietnamese line stays upright while the English line becomes italic inside the same cell.

Notes

• Cells that do not contain the delimiter are skipped and keep their formatting.
• It only works on cells holding static text; a formula cell cannot carry per-character formatting.
• Chunks 2, 4, 6 … are italicized; in a cell with three chunks the last one returns to regular style.
• This changes character formatting, not cell content — but Ctrl+Z usually cannot undo it across the whole range.
• Typing Chr(10) (any letter case) is interpreted as the line-break character; any other string is used literally.
• The ribbon tooltip says the delimiter is configured in Preferences, but the current build always asks for it through an input box when the command runs.

Related

• Font Change — same chunk-splitting logic, changing the font instead of the style.
• Merge keep data — builds the multi-line cells this command formats.
• AutoFit merged — sets the row height once cells hold several lines.
• Subscript — another per-character formatting command in the same group.