On Windows, press Control+ H to open the Replace dialog in most apps. To find something in most apps, just press Control+ F on a PC, or Command+ F on a Mac, type in what you're looking for, and the app will scroll down to that text and highlight the result. Ignore white space characters is a Word feature to ignore spaces in words.Find and Replace is built into most apps, especially text editors and word processors-and it works the same almost everywhere.Ignore punctuation characters is a Word feature to ignore punctuation marks like the single quote in 'don't.'.Match suffix is a Word feature to match the suffix (end) of a word.Match prefix is a Word feature to match the prefix (beginning) of a word.For example, searching for 'color' would find 'colour' in your document. Sounds like (English) is a Word feature to match English sounding words.Regular expression is the most powerful feature for finding and replacing text in a file.Use wildcards is a feature found in Word that allows you to use wildcards.If your program does not include one of the features below, you need to consider switching programs so you have access to 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. The 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.

Mass find and replace excel