PrecisionCalc
inspector text
Do Anything with Text in Formulas

(When inspector text is installed, this function reference is also available from within Excel by choosing Tools | inspector text | inspector text Help and Function Reference.)

Search & Replace Functions

• itCOUNTINCELL
  • Counts the occurrences of a given string in a worksheet cell, or within in any text string, allowing versatile and flexible criteria.
     
• itEXCLUDE
  • Excludes undesired characters from text.
     
• itEXCLUDENOTNUM
  • Excludes non-numeric and other undesired characters and/or digits from text, detecting the local decimal symbol, negative numbers, and exponential notation.
     
• itEXTRACT
  • Retrieves desired characters from text.
     
• itEXTRACTNUM
  • Retrieves numeric and other desired characters from text, detecting the local decimal symbol, negative numbers, and exponential notation.
     
• itFINDR
  • Same as Excel's built-in FIND function, but searches from right to left.
     
• itGETWORD
  • Returns the nth word in a string, with allowing versatile and flexible criteria for word separators.
     
• itMIDR
  • Same as Excel's built-in MID function, but searches from right to left.
     
• itREGEX
  • Performs a Regular Expressions search or replace.
     
• itREPLACE
  • Extremely versatile and flexible text replacement.
     
• itREPLACER
  • Same as Excel's built-in REPLACE function, but counts from right to left.
     
• itREVERSE
  • Reverses the characters in text right to left.
     
• itSEARCH
  • Extremely versatile and flexible text search.
     
• itSEARCHR
  • Same as Excel's built-in SEARCH function, but searches from right to left.
     
• itSUBSTITUTER
  • Same as Excel's built-in SUBSTITUTE function, but searches from right to left.
     

Fuzzy Comparison Functions

• itFUZZYCOMPARE
  • Compares two text strings. Returns the string they have in common, or a fuzzy comparison score.
     
• itISFUZZYMATCH
  • Compares two text strings and determines whether they are alike enough to meet a minimum fuzzy match score.

Miscellaneous Text Functions

• itST
  • Returns the English ordinal indicator of a cardinal number.
     
• itCONCATULA
  • Evaluates a concatenated formula, or any other all-text formula in which the operator is text.
     
• itFORMULA
  • Returns the formula of a cell.
     

Information Functions

• itTEST
  • Determines whether inspector text is working properly.
     
• itVERSION
  • Returns the version number of inspector text.

• itXLA
  • Returns the version number of the inspector text.xla file.

Using inspector text Functions in Code (VB, VBA, Etc.)

PrecisionCalc Home Page