I have a long document in Word that has a lot of data with the format ES- and 4 numbers that are changing ( ES-0006 , ES-0015 , ES-0164 , etc.) , and I need to change them for others that I have in an Excel sheet with the format R- and 4 numbers ( R-0001 , R-0002 , R-0003 , etc.).
In the Excel sheet, I have saved in the A column all the ES-xxxx that I used in the Word document and in the B column I have the R-xxxx for which I have to change them.
Now I am changing them one by one using Search and replace in Word : In Search I type the ES-XXXX that is in the column A of the sheet Excel and in Replace I type the R-XXXX that is on the right in the column and click on change all.
This is Word enter this sheet Excel and copy the contents of cell A-3 , return to the text, open the function Search and Replace with Word and paste it into the Search window. Then you must go back to this sheet Excel and copy the contents of cell B-3 and in Word paste the contents in the window Replace with the Search and Replace feature and activate Replace all . Once the first one is already replaced, you should do the same with cell A-4 and replace it in Word with the contents of cell B-4 and so on, until you find an empty cell.
Sheet Excel :
| A | B |
--+-------------+------------------+
1| Equivalencias |
--+-------------+------------------+
2| En el texto | Cambio para el |
| modelo | texto definitivo |
--+-------------+------------------+
3| ES-0001 | R-0001 |
4| ES-0003 | R-0002 |
5| ES-0008 | R-0003 |
6| ES-0010 | R-0004 |
7| ES-0020 | R-0005 |
8| ES-0030 | R-0006 |
9| ES-0040 | R-0007 |
10| ES-0050 | R-0008 |
11| ES-0070 | R-0009 |
12| ES-0080 | R-0010 |
13| ES-0086 | R-0011 |
14| ES-0094 | R-0012 |
15| ES-0100 | R-0013 |
16| ES-0151 | R-0014 |
17| ES-0163 | R-0015 |
18| ES-0170 | R-0016 |
19| ES-0240 | R-0017 |
20| ES-0263 | R-0018 |
--+-------------+------------------+
Would there be any way for Word to do it automatically and all at once?
