CTRL+F indicates the number of occurrences of a search term. However, when using regex (via Find and Replace) there's no indication of count.
Does anyone know how to find the number of occurrences when using regex?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
You could try something like this:
This replace the regex pattern your looking for with a symbol, then counts the number of times it occurs in your string, but counting the number of cells it splits into.
note: the extra space and the period at the end of the regexreplace, is there in case your pattern happens to be the last thing in the sentence, or cell value, that way it still has data to split into the final cell.