Skip to content

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

  1. Select the cells that need markers.
  2. Go to the DVD Addin tab → Text and Number group → open the Bullets menu → 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 +).

Example

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

BeforeAfter
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+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.
  • Since the cell is now Text-formatted, change it back to General first if you later want to enter a real formula there.
  • 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.

Released under DVDAddin License.