I am looking for following feature in ASAP Utilities:
Count number of user specified characters in a cell. e.g. I have a cell that has values "a,b,c,d,e". I would like to have a utility that tells me either
a. there are 4 "," characters
b. simply tell me that there are 5 characters separated by comma.
The first one could actually take a user input as a character for delimiter - it could be comma, semicolon, or any other character.
It would be nice if this feature were a part of excel / ASAP Utilities. Thanks.
You can do this with ASAP Utilities with the worksheet function ASAPCountChar:
This function returns the number of times the "SearchValue" occurs in the "SearchText". This way you can for example count the number of commas in a cell. This function is case sensitive.