Text Utilities

Auxiliary text-processing commands — conditional italic toggle, cleanup whitespace / tabs / line breaks, trim, grammar.

Italic Toggle

DVD Addin → group Text and Number → split-button Italic.

Toggle italic for the selected range — like Ctrl+I but with smart variants:

Sub-menu commands

Command	Purpose
Italic toggle	Toggle italic on entire range (like Ctrl+I)
Italic translated lines	Italic only the translated lines in multi-line cells
Italic after /	Italic the text after / (e.g. "Source / Target" → "Source / Target")
Italic after -	Same but with the dash separator
Remove italic	Remove italic

Italic translated lines

After Translate with option "Source / Target — new line":

Cell content:

Hello
Xin chào

Click Italic translated lines → "Xin chào" (line 2) becomes italic. Line 1 (source) stays.

Detects translated lines by even-line pattern (line 0 = source, line 1 = translation, line 2 = source, ...). Suitable when each cell has source/target pair.

Italic after /

Cell content:

Hello / Xin chào
Goodbye / Tạm biệt

Click Italic after / → text after / becomes italic (rich text):

Hello / *Xin chào*
Goodbye / *Tạm biệt*

Suitable when using Translate option "Source / Target — same line (//)".

Text Ops

DVD Addin → group Text and Number → split-button Text Ops.

Main commands

Command	Purpose
Trim spaces	Remove leading/trailing spaces
Trim internal	Remove excess spaces between words (e.g. 2+ spaces → 1)
Remove tabs	Remove tab characters
Remove line breaks	Remove \n (collapse to one line)
Replace line break	Replace \n with another character (e.g. ; )
Split text	Split one cell into multiple by separator
Concatenate	Join multiple cells into one
Find & Replace by regex	Replace using regular expression
Extract pattern	Extract substring matching a pattern

Trim spaces

Cell with " Hello " (with leading/trailing spaces) → click Trim spaces → "Hello".

Equivalent to =TRIM(A1) but:

• Applied in-place.
• Bulk for entire range.

Trim internal

Cell "Hello World" (4 spaces) → click → "Hello World" (1 space).

Split text

Cell A1 = "Hanoi; HCMC; Da Nang":

• Dialog → separator ; → output range = B1:D1.
• → B1 = "Hanoi", C1 = "HCMC", D1 = "Da Nang".

Equivalent to Excel Data → Text to Columns but:

• Simpler dialog (not a 3-step wizard).
• Supports multi-character separator (e.g. |).

Find & Replace by regex

Dialog:

• Range — selection.
• Pattern — regex (e.g. \d{4}-\d{2}-\d{2} = yyyy-MM-dd date).
• Replacement — e.g. [DATE].
• Test preview before commit.

Supports .NET Regex syntax. Suitable for:

• Cleanup data with patterns (PII, email, phone, code).
• Mass edit text format.

Translate (gateway)

DVD Addin → group Text and Number → click Translate.

→ See Translate.

Numbering

→ See Numbering.

Bullets

→ See Bullets.

License gating

All Text Utilities are free — no license required.

Exception: if a sub-menu links to AI (e.g. Smart Italic detect by AI — not yet implemented), those commands will be premium.

Related

• Smart Case — accurate case change for Vietnamese with diacritics.
• Encoding — convert between Unicode / TCVN3 / VNI.
• Translate — translate + apply italic to translated lines.