Find and replace words according to excel file

[laith93]

Hi,
I have a list of words and abbreviations in an excel file,
I want to use this list to search and replace words in a word document, and if possible to preserve words formating in the excel file during replacing, eg:

Demo:
Urinary tract infection (uti) are considered to be the most common and important bacterial infection, elisa test, E. coli most common infectious agent.

Excel file with desired formatting words:
UTI
ELISA
E. coli



After applying code:
Urinary tract infection (UTI) are considered to be the most common and important bacterial infection, ELISA test, E. coli most common infectious agent.

Please any help?
Thank you

[Guessed]

Search and replace from an Excel table is relatively straightforward but if you want to include formatting as well it becomes a whole different ballgame.

I would recommend the source table be in Word format so you have more flexible formatting options which don't require special handling. Are you able to set up a Word source for the replacements or does it HAVE to be in Excel?

[laith93]

Originally Posted by Guessed

I would recommend the source table be in Word format so you have more flexible formatting options which don't require special handling.

Thank you for your reply Mr. Andrew
Good idea

[laith93]

Originally Posted by Guessed

Are you able to set up a Word source for the replacements or does it HAVE to be in Excel?

It doesn't matter, as you like, it's just an idea by me (according to an excel file), but keep in your mind Mr. Adrew
I want to ignore cases during searching, e.g

Search for: fimH and fyuA, FimH, FyuA, FIMH, FYUA (the same abbreviations)
Replace to: fimH and fyuA

See attachment files with my special thanks.

[gmayor]

See https://www.gmayor.com/document_batch_processes.htm which will process all the document ranges and will include the formatting in the table.

[laith93]

Originally Posted by gmayor

See https://www.gmayor.com/document_batch_processes.htm which will process all the document ranges and will include the formatting in the table.

Thank Mr. Ghram for this awesome and great add-in
Excuse me Mr. Ghram, can you clarify these points:

1:
I want to replace fimH, FimH, and FIMH to fimH, so I used different combination by typing (Y,N,N), (N,Y,N), (Y,Y,N), ...etc
but without benefit, so which combination is better for this case?

2:
When I left the columns (WC, WWo, OMIT) blanks, it does affect the results?

3:
When I type (Y) for a certain column, is necessary to type (N) for other columns?

4:
I didn't understand (OMIT) what can do, I want more explanation, please?

5:
I added (Process Documents) to QAT, so I want to hide Batch Process tab.

Thank you again

[gmayor]

To replace fimH, FimH, and FIMH with fimH you will need three rows in the table with (or nothing) in the WC column.
It is not necessary to enter N. The process looks for Y.
If the OMIT column has Y then that row is not included in the process.
The only way to remove the Batch Process tab would be to use the Office Ribbon X editor to remove the add-in's ribbon. I would caution against doing so as it may render the process unusable.
If you use it only occasionally, you may find Load Word add-ins for the current session only useful.

[laith93]

Originally Posted by gmayor

To replace [FONT=&quot]fimH, FimH, and FIMH with fimH you will need three rows in the table with (or nothing) in the WC column.

Thank you, I have got the idea.

Originally Posted by gmayor

[FONT=&quot]The only way to remove the Batch Process tab would be to use the Office Ribbon X editor to remove the add-in's ribbon. I would caution against doing so as it may render the process unusable.

Ok, Mr. Graham
My problem with this tab is taking large space and you can't rearrange it or add custom commands to this tab, because it hidden by default
04.png

Originally Posted by gmayor

[FONT=&quot]It is not necessary to enter N. The process looks for Y.

Lastly, Mr. Graham
I made my table without entering (Y or N) to any column, and it produces my desired results, so I think Y or N is not necessary in my case, is right??? see
12.png

Thank you