Microsoft Office Forums How to increment numeric value in embedded table?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2019, 07:20 PM
rosede rosede is offline How to increment numeric value in embedded table? Windows 7 64bit How to increment numeric value in embedded table? Office 2013
Novice
How to increment numeric value in embedded table?
 
Join Date: Nov 2012
Posts: 6
rosede is on a distinguished road
Default How to increment numeric value in embedded table?


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
Reply With Quote
  #2  
Old 05-22-2019, 08:36 PM
macropod's Avatar
macropod macropod is offline How to increment numeric value in embedded table? Windows 7 64bit How to increment numeric value in embedded table? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,596
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-30-2019, 04:46 PM
rosede rosede is offline How to increment numeric value in embedded table? Windows 7 64bit How to increment numeric value in embedded table? Office 2013
Novice
How to increment numeric value in embedded table?
 
Join Date: Nov 2012
Posts: 6
rosede is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
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
Reply With Quote
  #4  
Old 05-30-2019, 04:50 PM
macropod's Avatar
macropod macropod is offline How to increment numeric value in embedded table? Windows 7 64bit How to increment numeric value in embedded table? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,596
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You really should re-read the last line of my post before the note...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 06-05-2019, 03:25 PM
rosede rosede is offline How to increment numeric value in embedded table? Windows 10 How to increment numeric value in embedded table? Office 2016
Novice
How to increment numeric value in embedded table?
 
Join Date: Nov 2012
Posts: 6
rosede is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You really should re-read the last line of my post before the note...

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
Reply With Quote
  #6  
Old 06-05-2019, 05:19 PM
macropod's Avatar
macropod macropod is offline How to increment numeric value in embedded table? Windows 7 64bit How to increment numeric value in embedded table? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,596
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You might at least try it...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to increment numeric value in embedded table? Multiple rows embedded in Table Row JimThomson4 Word Tables 2 08-20-2018 04:24 PM
Export embedded .txt or .csv file from Word bookmark to Access table field eric.okeefe Word VBA 4 08-29-2017 09:31 AM
Linking between embedded excel and word table SFG Word Tables 3 05-03-2017 12:25 AM
Scroll bar problem with an embedded Excel table chrisge Word 1 09-26-2013 06:18 PM
update one embedded excel table based on another excel table ajetrumpet Word 0 07-05-2013 08:51 PM


All times are GMT -7. The time now is 05:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft