PrecisionCalc
inspector
text
Do Anything with Text in Formulas
Revision History:
inspector text 1.0 (January 25, 2006)
Has inspector
text been updated for
Excel 2016?
November 20, 2015
inspector text has been tested with Excel 2016 (32-bit). It worked perfectly, with no problems of any kind.
Although inspector text works with 32-bit Excel 2016, it will need to be updated to work with 64-bit Excel 2016.
Has inspector
text been updated for
Windows 10?
September 14, 2015
inspector text has been tested with Windows 10. It worked perfectly, with no problems of any kind, so it is not necessary to update it for Windows 10. You can use inspector text in Windows 10 with confidence.
Has inspector
text been updated for
Windows 8.1?
November 4, 2013
inspector text has been tested with Windows 8.1. It worked perfectly, with no problems of any kind, so it is not necessary to update it for Windows 8.1. You can use inspector text in Windows 8.1 with confidence.
Has inspector
text been updated for
Excel 2013?
July 12, 2013
inspector text has been tested with Excel 2013 (32-bit). It worked perfectly, with no problems of any kind.
Although inspector text works with 32-bit Excel 2013, it will need to be updated to work with 64-bit Excel 2013.
Has inspector
text been updated for
Windows 8?
December 8, 2012
inspector text has been tested with Windows 8. It worked perfectly, with no problems of any kind, so it is not necessary to update it for Windows 8. You can use inspector text in Windows 8 with confidence.
Has inspector
text been updated for
Windows 7?
January 15, 2010
inspector text has been tested with the final release of Windows 7. It worked perfectly, with no problems of any kind, so it is not necessary to update it for Windows 7. You can use inspector text in Windows 7 with confidence.
Has inspector
text been updated for
Excel 2010?
January 9, 2010
In the 32-bit version of Excel 2010, inspector text worked perfectly, with no problems of any kind. You can use inspector text in the 32-bit version of Excel 2010 with confidence.
However, inspector text does not currently work with the 64-bit version of Excel 2010. inspector text will need be updated to work with the 64-bit version of Excel 2010.
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.