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

 A
1??

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.



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