inspector
text
Find It. Control It.
You're In Charge.
What's new in inspector text 2.1?
inspector text 2.1 adds itFORMULA. itFORMULA returns the formula of a referenced cell, as text.
What's new in inspector text 2.0?
inspector text 2.0 adds two fuzzy matching functions -- the easy to use itISFUZZYMATCH and the very powerful and versatile itFUZZYCOMPARE.
For a complete list of inspector text functions, see the Function Reference.
inspector text 2.0 offers 6 easy to use functions that assist in searching from the right and reversing text: itREVERSE, itFINDR, itSEARCHR, itREPLACER, itSUBSTITUTER, itMIDR.
itREVERSE accepts a single text argument and reverses the order of its characters, right to left.
itFINDR, itSEARCHR, itREPLACER, itSUBSTITUTER, and itMIDR work exactly like the built-in Excel functions FIND, SEARCH, REPLACE, SUBSTITUTE, and MID, but search or count from the right instead of from the left.
These 6 functions were available on request as inspector text version 1.5, but had not yet been included in a general release or included with the free edition download. In version 2.0, these functions are included in all copies and editions of inspector text.