*
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.

- 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.

- 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.

- 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.

- Retrieves desired characters from text.
- itEXTRACTNUM
- Retrieves numeric and other desired characters from
text, detecting the local decimal symbol, negative numbers, and exponential
notation.

- 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.

- 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.

- 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.

- Same as Excel's built-in MID function, but searches
from right to left.
- itREGEX
- Performs a Regular Expressions search or replace.

- 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.

- Same as Excel's built-in REPLACE function, but counts from
right to left.
- itREVERSE
- Reverses the characters in text right to left.

- 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.

- 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.

- 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.

- 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.

- Returns the English ordinal indicator of a cardinal
number.
- itCONCATULA
- Evaluates a
enated form**concat**, or any other all-text formula in which the operator is text.**ula**

- Evaluates a
- itFORMULA
- Returns the formula of a cell.

- Returns the formula of a cell.

Information Functions

- itTEST
- Determines whether inspector text is working properly.

- 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.)