August 13, 200421 yr In response to a thread on another forum, here is a Custom Function that will return the number of consecutive occurrences of the specified character or character type (digit/alpha) with the specified frequency (consecutively) for the given text. For example, if the text is AABBABBBA1, the character is A, and the frequency is 2, then the result will be 1. If the character is B, the result will be 2. If the character is 'digit' and 1 is the frequency, 1 is the result; if 'alpha', then 9. Note that this function is case-insensitive and will not work for compound characters, e.g. 'ab', '49'. RegExp.zip
Create an account or sign in to comment