HandyFile Find and Replace: Office Edition 3.4.4 - User Guide and FAQ

Frequently Asked Questions - HandyFile Find and Replace: Office Edition

1. What are Regular Expressions?
   Regular expressions are a way to search for substrings ("matches") in strings. This is done by searching with "patterns" through the string.
   
   
2. Why can we use Regular Expressions?
   Example usages could be:
   1. Remove all occurrences of a specific tag from an html file.
   2. Check whether an e-mail address is well-formed.
   3. Replace value of some tag attribute with a different one.
   
   
   
3. How to find and replace text in word and excel files?
   To find the Microsoft Office file(s) of the required type and replace text in them, do the following:
   1. Specify the folder in which you want to find files. For example: C:\MyOfficeFiles
   2. Set mask(s) of the files that you want to find.
      • To search for the native Microsoft Word files (.doc), set the filter to *.doc.
      • To search for .rtf files to be processed with Microsoft Word, set the filter to *.rtf.
      • To search for both .doc and .rtf files to be processed with Microsoft Word, set the filter to *.rtf;*.doc.
      • To search for Microsoft Excel files (.xls), set the filter to *.xls.
      • If you need to process both Microsoft Excel and Microsoft Word files, set the filter to *.rtf;*.doc;*.xls.
   3. Type in the text that you want to find in the Find What field.
   4. Enter the text that you want to replace the found text in the Replace With field.
   5. The Microsoft Office searches allow using the Case-sensitive search. If you need to find text exactly as you have typed, check this option.
   6. Make sure the option Search only is unchecked.
   7. Click the Replace button.