(None)

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

Command ID: btnNone_1

What it does

Strips bullet symbols from the selected cells and returns the content to plain text. The command recognises exactly the symbol set that the Bullets menu inserts — − • + * ○ ● □ ■ ◇ ◆ ☆ ★ ☐ ☑ ☒ — and removes one symbol from the start of each line together with the space that follows it.

Use it when a bulleted method statement has to become running prose for a Word submission, or to clean cells before switching to a different symbol. The apply commands in this menu already run the strip step themselves, so (None) is only needed when you want the bullets gone for good.

How to use

1. Select the cells that currently carry bullets.
2. Go to the DVD Addin tab → Text and Number group → open the Bullets menu → choose (None).
3. For text cells: each line inside the cell is trimmed of surrounding whitespace, then its leading bullet is removed if one is present.
4. For formula cells: the add-in unwraps only the wrapper it added itself (the =""&"● "&(...) form) and restores the original formula, still live.
5. The status bar reports Processed N cells (bullets).

Example

A multi-line method-statement cell in a submittal:

Before	After
● Clear the area and set out pile centres ● Bore to design level ● Lower the cage and pour concrete	Clear the area and set out pile centres Bore to design level Lower the cage and pour concrete

The text is now symbol-free, ready to paste into a Word method statement or to renumber with Numbered list.

Notes

• Each run removes one symbol per line; if a cell somehow carries two stacked bullets, run the command twice.
• The keyboard hyphen - is not in the recognised set — only the mathematical minus − inserted by the Minus command is stripped.
• Cells holding numbers, dates, or TRUE/FALSE are left completely untouched, so a date is never flattened into a serial number.
• A formula you wrote yourself, such as ="A. "&(B1), is not disturbed; the add-in only unwraps its own wrapper.
• Ctrl+Z will not undo the change, and hidden rows and columns are skipped.

Related

• Filled circle — the bullet style used most often in method statements.
• Checkbox — empty-box symbol, also removed by this command.
• (None) for numbered lists — the matching command for the Numbered list menu, stripping 1., I., A. prefixes.
• Numbered list — renumber with 1., 2., 3. after clearing the symbols.