Find and replace words according to excel file

Guessed · #1 12-09-2021, 03:20 PM

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 · #2 12-09-2021, 08:14 PM

Quote:

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 · #3 12-09-2021, 08:21 PM

Quote:

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find & Replace Multiple words	Gartholameau	Word VBA	2	01-20-2019 04:56 PM
multiple find and replace in vba for special words	kvnrao	Word VBA	7	11-02-2018 06:28 PM
Find and replace mutiple spaces between lowercase words only	Dave T	Word VBA	2	07-16-2015 11:23 PM
VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File	QA_Compliance_Advisor	Word VBA	11	09-11-2014 11:51 PM
Find & Replace: substitute red-coloured words with underscores	tinfanide	Word	2	10-06-2012 11:04 PM