We made this version more user friendly with its new stepwise process. It has Three steps:
In this step you can add words or phrase for Find What and Replace With List Set by Set or from a Comma/Line Separated Text file. You can type word and press enter or click "Add to List" button to add the same on Word List below. To add Words from TXT file just check the Find What or Replace With radio button and click "Load List" to Add Words.
Find What: Enter word in this text box to Find. You can also find
special characters like Paragraph Marks, Tab Characters, Manual Line Breaks and all special
characters available in MS-EXCEL FILE which is not listed here. You can also use Wildcard
Characters (*).
Replace With: Enter word in this text box to Replace. You can also
replace special characters like Paragraph Marks, Tab Characters, Manual Line Breaks etc. as you do
in MS-EXCEL FILE.
Find Options: Before adding word set select your desired find
options.
Match Case: Check this option if you want your search to be case
sensitive.
Match entire cell content:Check this option if you want your search to be cell
specific.
Replace in All Sheets: Check this option if you want to search and replace in
entire workbook.
Replace in First Sheet: Check this option if you want to search and replace only
in first sheet of workbook.
Format Words & Final Process- In this step you can format or highlight your
selected words or phrases for Find What and Replace With List or you can also
Edit the Text and change the Find Options.
Click on a Word in the List to open format panel. Format Panel has four bars.
First Bar | |
Second Bar | |
Third Bar | |
Fourth Bar |