Plus

Location on ribbon: Tab DVD Addin → Group Text and Number → arrow on Numbering → section Bullets

Command ID: btnPlusSign

What it does

Prepends a plus sign + plus a space to every line inside the selected cells. Because + is plain ASCII it renders identically on every font and every machine — including a PC without full Unicode fonts, and when the content is exported to CSV, pushed into estimating software, or pasted into an email.

On site paperwork, + usually marks additions: variation quantities, items added outside the contract, or the components that build up a unit rate.

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 Plus.
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 Variations), so you can follow each step right away.

Step 1. Select the cells that need the bullet — here the variation items (1).

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

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. Each cell now starts with + (1) — a plain ASCII character, so it shows on every font and survives a CSV export. The status bar reports how many cells were processed (2).

Example

The "Description" column of a variation quantity appendix submitted to the client:

Before	After
Add 12 m³ of M100 blinding concrete Add 850 kg of D16 strengthening links Add 45 m² of pile cap side formwork	+ Add 12 m³ of M100 blinding concrete + Add 850 kg of D16 strengthening links + Add 45 m² of pile cap side formwork

Notes

• Text cells are switched to Text format (@) before the write, which is what stops Excel from reading a string that starts with + as a formula and rejecting the entry.
• Cells holding numbers, dates, or TRUE/FALSE are skipped entirely.
• 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.
• Since the cell is now Text-formatted, change it back to General first if you later want to enter a real formula there.

Related

• Minus — the opposite marker, useful for omissions and deductions.
• Asterisk — another ASCII marker that survives any export.
• Remove bullets — strip markers from the selection.
• Filled circle — the standard bullet for printed method statements.