Asterisk

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

Command ID: btnAsterisk

What it does

Prepends an asterisk * plus a space to every line inside the selected cells. Being plain ASCII, the asterisk renders identically everywhere and survives a CSV export or a paste into another application unchanged.

In construction documents the asterisk is the familiar marker for footnotes, table caveats, and the conditions attached to a rate — the "*Rate excludes VAT" line at the bottom of a summary.

How to use

1. Select the cells that need markers.
2. Go to the DVD Addin tab → Text and Number group → open the Bullets menu → choose Asterisk.
3. The add-in strips any existing bullet first, then handles each cell:
   • Text cell — * is added at the start of every line.
   • Empty cell — just * is written.
   • Formula cell — wrapped as =""&"* "&(original formula), so the marker shows while the formula stays live.
4. The status bar reports Processed N cells (bullet *).

Example

The footnote cell under a tender price summary:

Before	After
Rates exclude VAT Provisional value, to be settled on measured quantities Applies to work certified before 31 December	* Rates exclude VAT * Provisional value, to be settled on measured quantities * Applies to work certified before 31 December

Notes

• Text cells are switched to Text format (@) before the write, so a string beginning with * is stored literally rather than being reinterpreted.
• Cells holding numbers, dates, or TRUE/FALSE are skipped entirely.
• Once * is in the cell, plain Find no longer matches it the obvious way — the * in the cell is a literal character while * in the Find box is a wildcard, so search for ~* instead.
• Ctrl+Z will not undo the change; use (None) to remove the markers.
• Hidden rows and columns are skipped, and each merged area is processed once, at its top-left cell.

Related

• Plus — the companion ASCII marker, used for added items.
• Filled star — the heavier Unicode version, better for printed submittals.
• (None) — strip markers from the selection.
• Filled circle — the standard bullet for body text.