(None)

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

Command ID: btnNone_2

What it does

Strips the numbering prefix from the start of every line in the selected cells, leaving plain text. The command recognises the four prefix styles the Numbered list menu produces — digits 1., Roman numerals I., uppercase letters A., and lowercase letters a. — together with the period and any spaces that follow.

Use it when rows were inserted or deleted mid-table and the numbering has to start over, when switching from digits to Roman numerals, or when the text must be handed to Word clean so Word's own automatic numbering can take over.

How to use

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

Note that the apply commands in this menu already run the strip step before renumbering, so (None) is only needed when you want the numbers gone entirely.

Example

The "Description" column of a quantity schedule after two rows were inserted mid-table and the old numbering went out of step:

Before	After
1. Machine excavation of foundation pits	Machine excavation of foundation pits
2. M100 blinding concrete to foundations	M100 blinding concrete to foundations
3. Fabricate and fix foundation reinforcement	Fabricate and fix foundation reinforcement
3. Erect pile cap formwork	Erect pile cap formwork

With the column clean, click Numbered list to renumber 1. through 4. in one pass.

Notes

• This command does not switch cells to Text format, so ordinary text cells keep whatever format they already had.
• Each run removes one prefix per line, and only the period style is recognised — prefixes such as 1) or a) are left in place.
• Watch out for genuine content that begins with a single letter or a run of Roman-numeral letters followed by a period: D. Nguyen Van A or CH. 12+500 is also read as a prefix and removed.
• Cells holding numbers, dates, or TRUE/FALSE are untouched, and a formula you wrote yourself such as ="A. "&(B1) is not disturbed.
• Ctrl+Z will not undo the change, and hidden rows and columns are skipped.

Related

• Numbered list — renumber 1., 2., 3. once the column is clean.
• Roman list — switch to I., II., III. for the major sections of a document.
• (None) for bullets — the matching command in the Bullets menu.
• Multilevel numbering — for 1.1.1. numbering driven by each cell's indent level.