COUNTSUBSTRING
Returns the number of times a substring occurs in a larger text string.
| decimalUnitSingle | (Optional) The unit to use for 'single' decimal numbers. |
Remarks
* The equivalent VBA function is COUNTSUBSTRING
|
COUNTSUBSTRING = ASAPCOUNTCHAR(within_text, find_text)
Counts the number of times a character occurs in a text
This way you can for example count the number of commas in a cell. This function is case sensitive.
Parameters:
within_text = The text containing the character you want to count.
find_text = The character to count the occurrences of. This has to be a single character.