Asterisk

Location on ribbon: Tab DVD Addin → Group Text and Number → arrow on Numbering → section 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 → arrow on Numbering → Bullets section → 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 *).

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Dấu đầu dòng · 5 min 03 s · 9 cases · Download the video · Practice workbook for the video

Commands in this video: Filled circle · Asterisk · Filled diamond · Filled star · Checkbox · Minus · Remove bullets · Plus · Checked · Rejected

Chapters (14)

1. Giới thiệu
2. Mở lệnh
3. Chín ký hiệu
4. 1 · Ô nhiều dòng
5. 2 · Đổi ký hiệu, chọn rời
6. 3 · Danh mục kiểm tra đang lọc
7. 4 · Ô trống – mẫu in sẵn
8. 5 · Ô số, ngày tháng
9. 6 · Ô công thức
10. 7 · Ô gộp
11. 8 · Bỏ ký hiệu đầu dòng
12. 9 · Ghi đè và hoàn tác
13. Mẹo
14. Kết thúc

Illustrated walkthrough

Practice

Download this command's sample workbook — the data matches the pictures below (sheet Summary), so you can follow each step right away.

Step 1. Select the notes cell under the table — a merged cell with one condition per line (1).

Step 2. On the ribbon, open the DVD Addin tab → Text and Number group → open Numbering → choose Asterisk.

Step 3. The Confirm data change box tells you how many cells will be overwritten. Keep Back up sheet ticked (1) so that Ctrl+Z right after the command restores the sheet, then click Continue (2).

Step 4. Every line of the notes cell now starts with * (1). The status bar reports how many cells were processed (2) — a merged cell counts once.

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.
• Applied by mistake? Ctrl+Z right after the command puts the cells back (it backs the sheet up first); later on, use Remove bullets 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.
• Remove bullets — strip markers from the selection.
• Filled circle — the standard bullet for body text.