Plus
Location on ribbon: Tab DVD Addin → Group Text and Number → Menu 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
- Select the cells that need markers.
- Go to the DVD Addin tab → Text and Number group → open the Bullets menu → choose Plus.
- 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.
- Text cell —
- The status bar reports
Processed N cells (bullet +).
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.
Ctrl+Zwill 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.
- 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.
- (None) — strip markers from the selection.
- Filled circle — the standard bullet for printed method statements.