Do Anything with Text in Formulas
Download inspector text Free Edition
On Windows NT, 2000, XP Vista, and Windows 7, 8, and 10, you must be logged in as an Administrator during installation.
On Windows Vista, 7, 8, and 10, start Setup by right-clicking inspector_text_2.0.2.exe and choosing "Run as administrator":
After installation, you no longer need to be logged in as an Administrator.
After installing inspector text, restart Excel.
Then, to verify that inspector text is installed and working properly, enter this formula in any spreadsheet cell:
It should return a welcome message with your name and the inspector text version. If itTEST() instead returns the "#NAME!" error, the most likely problem is that your Windows configuration simply did not allow the setup program to register inspector text as an add-in in Excel. No problem, it's easy to just do that manually:
Steps to manually register inspector text as an add-in in Excel:
In Excel 2010, 2013, and 2016:
- File > Options > Add-ins > Go (button). That should bring up the Add-ins dialog.
- In the Add-ins dialog, click Browse, and browse to inspector_text.xla. Then click OK, and inspector text should be listed there in the Add-ins dialog and checked.
- Then click OK to get back to Excel. itTEST() should work then, but if not try restarting Excel.
In Excel 2007, the steps are the same as above except that instead of File > Options, it's:
- Office Button > Excel Options (button)
In Excel 2003 and earlier, the steps are the same as above except that instead of File > Options > Add-ins > Go (button), it's just:
- Tools > Add-ins
If those steps don't fix the problem, you may wish to try installing again, or see the Troubleshooting FAQ, or email for help.
Once you've gotten itTEST() working, find the inspector text online help by choosing Add-Ins > inspector text 2.0 > inspector text 2.0 Help and Function Reference:
In Excel 2003 and earlier, inspector text's online help is in Tools > inspector text 2.0 > inspector text 2.0 Help and Function Reference:
PrecisionCalc Home Page