View Single Post
 
Old 01-15-2021, 04:09 PM
mbcohn mbcohn is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Jan 2021
Posts: 32
mbcohn is on a distinguished road
Default find and replace a number that's always in a table and always adjacent to a cell with known text

I have a series of documents that all contain identical formatting.
Each has a table that contains a cell with the value "Revision No."
Then, in the cell just to the right of that first cell, there is another cell, containing a number. So it looks kind of like this:
Revision No. 6
Except that "Revision No." and "6" are in different cells.
So, I need to programatically (because there are many documents) update the numbers.
I don't want to do a normal find and replace because, of course, the number 6 might occur in other places throughout the document, and I don't want to replace those. I only want to replace the one that represents the revision number.

If this is too hard, then there might be other ways to identify the exact cell where the revision number occurs. It does tend to be in the same position, relative to the whole table, in every document. However, I am not 100% sure that there are no exceptions.
Reply With Quote