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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext