[jvr]

How to replace multiple words with replacement words in Excel


In my Word documents, I must use temporary €œIdentifiers€� (internal temporary
codes; supplied to me) that must be later replaced with actual €œIdentifiers€�
(in an Excel file supplied by the customer much later and perhaps multiple
times).

The actual €œIdentifiers€� in the Excel file are €œpaired€� with my temporary
€œIdentifiers€� (as two cells, side-by-side).

For example:
PTT-001 205-PTT-0924
PTT-124 205-PTT-0020
Meaning:
For each instance of PTT-001 replace with 205-PTT-0924,
for each instance of PTT-124 replace with 205-PTT-0020,
etc. (there may or may not be any particular pattern).

There will be hundreds of these €œpairs€� and each one may be in the document
zero, one, or more times.

Doing this manually with €œFind and Replace€� is extremely time-consuming.

Thanks so much in advance for any solution.

I really appreciate it.