Returns the number of times a substring occurs in a larger text string.
|decimalUnitSingle||(Optional) The unit to use for 'single' decimal numbers.|
* 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.
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.
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext