document inspector in excel what does it do

I have uninstalled Office 2010, cleaned registry, and reinstalled Office 2010 and get the same result. I have the same result in PowerPoint 2010 and there are a few more categories. Inspector text's search & replace functions are extremely versatile, flexible, adaptable, and detailed. When I run Document Inspector in Word 2010 or Excel 2010, the last 4 categories return this message: 'This inspection did not complete successfully'. There is nothing else on the market like. Sure, other add-ins do menu-based search & replace and even simple fuzzy matching. Inspector text also adds worksheet formula functions that: But compare what you can do with inspector text in your worksheet formulas, and you'll never look back. They are vastly more powerful and useful than the search & replace functions built into Excel, yet are easy to use and do not require any special knowledge. Exclude or retrieve lists of characters from text. Use several powerful wildcards and substitutions. Search from left to right or from right to left. Click on 'Document Properties' in the top-left corner of the Document Panel. Tip: In Excel 2007, please click Office Button > Prepare > Inspect Document, see screenshot: 2. The first way to display the Advanced Properties is right from the Document Panel. Restrict search to text that appears before (or does not appear before) other text you specify. If you can't find the necessary information in the Document Panel, take the Advanced Properties into use. If replacing text, rearrange text as desired, instead of (or in addition to) replacing it. Return any of 22 kinds of information about the text found. Choose a friendly, custom text message to return if no match is found, instead of returning a standard error, if desired. Inspector text's fuzzy matching worksheet formulas allow you to determine whether or not the text in two cells is similar, or find the characters they have in common. They can also be used to find the text items in a list that are most similar to a target text item. Finally, you can easily find the needle in that haystack! There is nothing else on the market like inspector text.

Click the Remove All button next to a category’s. The document is analyzed, and any instances of the selected hidden data are noted. Select which hidden data you want to check for, then click Inspect. Sure, other add-ins do menu-based search & replace and even simple fuzzy matching. This lists all of the kinds of hidden data you can find in a document.

Document inspector in excel what does it do