I have a 2016 Word doc with an embedded table. This table had multiple cells with digits ranging from 1 to 96. Each cell is duplicated so there are two cells with a number 1, two cells with a number 2 all the way up to two cells with a 96.



I want to restart the numbering sequence at 97 and then increment up to 192. How can I do this automatically? I've played with the Find/Replace, but I realize that I cannot auto-increment. My guess is that I probably need to use a formula of some kind, but I don't know the syntax and have no idea how to write the formula.

Any suggestions on how to update these numbers will be greatly appreciated.

Thank you.

Daryl

Simple. Assuming it's a two-column table:
1. Insert a field in the first cell, coded as:
{SEQ Nr \r {FILLIN "Starting #"}}
2. In all remaining cells in the first column, insert fields coded as:
{SEQ Nr \n}
3. In all cells in the second column, insert fields coded as:
{SEQ Nr \c}

To update select the entire table and press F9.

Note: The field brace pairs (i.e. '{ }') for the above examples are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sorry for my late response. Been very busy.

I tried your solution, and it does work, however, I have to touch every cell and put this formula in each cell that I want changed. I just can't simply copy/paste the formula, I have to CTRL + F9 each and every cell so I can insert the formula. There are 192 cells, and if I have to touch each and every cell with that formula, it's going to take me hours.

Is there a better way?

Thank you.

Daryl

You really should re-read the last line of my post before the note...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes, I read the last line, but this isn't the only information in the table. This table has multiple cells with other data in those cells. If I press F9 to select the entire table, what will that do to the the cells with other data in them?



Thanks


Daryl

You might at least try it...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]