![where is the document inspector in excel where is the document inspector in excel](https://www.excelarticles.com/image/LE10000094.png)
![where is the document inspector in excel where is the document inspector in excel](https://www.sageintelligence.com/wp-content/uploads/2014/07/tip-34.png)
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. Sure, other add-ins do menu-based search & replace and even simple fuzzy matching. There is nothing else on the market like inspector text. Finally, you can easily find the needle in that haystack!
![where is the document inspector in excel where is the document inspector in excel](https://www.techyv.com/sites/default/filesx/users/Techyv-Images/Document-Inspector-Window.jpeg)
They can also be used to find the text items in a list that are most similar to a target text item. 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. Choose a friendly, custom text message to return if no match is found, instead of returning a standard error, if desired. Return any of 22 kinds of information about the text found. If replacing text, rearrange text as desired, instead of (or in addition to) replacing it. Restrict search to text that appears before (or does not appear before) other text you specify. Search from left to right or from right to left. Use several powerful wildcards and substitutions. 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. Inspector text's search & replace functions are extremely versatile, flexible, adaptable, and detailed. Inspector text is an Add-In for Microsoft Excel that adds powerful worksheet formula functions for manipulating and working with text in worksheet cells, including search & replace, and fuzzy matching.