PrecisionCalc
inspector
text
Do Anything with Text in Formulas
Revision History:
inspector text 1.0 (January 25, 2006)
What's new in inspector text 2.0.2?
May 15, 2009
inspector text 2.0.2 fixes a bug reported today where if Excel was started by opening an Excel workbook that has a file-open password, inspector text returned error 50290.
inspector text 2.0.2 also adds itXLA, for getting the version of the inspector text.xla file.
The Free Edition has been updated to version 2.0.2.
Version 2.0.2 is a free upgrade for version 2.0.x users on request.
What's new in inspector text 2.0.1
Free Edition?
May 11, 2009
inspector text 2.0.1 makes the Free Edition easier to use. For example:
What's new in inspector text 2.0.1?
March 26, 2009
inspector text 2.0.1 fixes a bug that was reported today in itFUZZYMATCH and itFUZZYCOMPARE in which under some circumstances it would not complete all submatch passes, resulting in a lower fuzzy comparison score.
Version 2.0.1 is a free upgrade for version 2.0 users on request. Versions earlier than 2.0 are not affected because they did not have the affected functions.
What's new in inspector text 2.0?
April 30, 2008
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.
Has inspector
text been updated for
Excel 2007 and Windows Vista?
May 31, 2007
inspector text has been tested with the final release versions of Excel 2007 and Windows Vista. It worked perfectly, with no problems of any kind, so it was not necessary to update it. You can use inspector text with Excel 2007 and Windows Vista with confidence.
What's new in
inspector text 1.5?
March 16, 2006
inspector text 1.5 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.
inspector text 1.5 is a free upgrade for 1.x owners. If you want to upgrade to 1.5, send me an email.
What's new in
inspector text 1.02?
March 10, 2006
inspector text 1.0.2 fixes a bug reported today where inspector text functions sometimes returned an error if the find_text argument was a cell reference.
What's new in
inspector text 1.01?
March 9, 2006
inspector text 1.0.1 fixes a bug reported today where sometimes Excel 2002 and earlier hung when starting after inspector text had been installed.