If your program does not include one of the features below, you need to consider switching programs with these features. More advanced programs may have the features mentioned below. For example, using regular expressions you can replace text found at the beginning of a line, end of the line, works containing a certain amount of characters, and anything else you need. Programs like Microsoft Word that support wildcards and programs like Notepad++ and TextPad that support regular expressions help perform a search for almost anything imaginable. For example, a search for 'can' only matches 'can' and would not match 'cannot' or scan' in your file. Match whole word matches the whole search instead of words containing the word.Match case makes the search case-sensitive, which is useful for finding searches like Names.The basicsĪll the replace options have the two basic features shown below. Using Search and Replace and advanced optionsĪfter understanding the above basics on how to open the search and replace features, understanding all the capabilities possible can make your searches even more efficient. On the Replace tab, enter the text you want to find and replace in the spreadsheet. Once the shortcut key opens or you click the Replace option under Find & Select, a Find and Replace window opens. Newer versions of Excel feature a Ribbon menu, and the Find & Select option is found on the Home tab, at the far right side as shown in the picture.

In Microsoft Excel, older versions featured the Edit menu, and the Replace option is found in that menu. SearchAndReplaceInStory Ctrl+ F and Command+ F keyboard shortcut keys also work in Microsoft Excel and other spreadsheet programs to open the Find and Replace text box. PNewFontName = 'Font Dolores' 'replace with the font you really need to have in your doc POldFontName = 'FontDoe' 'replace with the font you want to replace Thanks Harry Spier, even though I had to modify your code a little - finally it works great! Sub FindReplaceAnywhere() SearchAndReplaceInStory, pOldFontName, pNewFontName, pFindTxt, pReplaceTxt SearchAndReplaceInStory rngStory, pOldFontName, pNewFontName, pFindTxt, pReplaceTxt 'Iterate through all story types in the current documentįor Each rngStory In ActiveDocument.StoryRanges LngJunk = ActiveDocument.Sections(1).Headers(1).Range.StoryType 'Fix the skipped blank Header/Footer problem It does a search not only on a text string but also on a particular font which it changes. Thank you Chrismas007 for the link to the 'complete answer' based on that link which I'm posting below for anyone else who needs this.

Microsoft word find and replace mac