Marco Bortolotto
Reputation: 3
Counting string sequence inside a cell
I have a string such as "0000xxx0xxx0xx00xxxxxx0xx0xxxxx" in an Excel Cell
I want to count how many times a sequence of more than three "x" appears, in other words, how many times a sequence such as "xxx" or "xxxx" and so on appears in this cell.
The output would be 4 times for this example.
Upvotes: 0
Views: 122
Answers (2)
JvdV
Reputation: 75840
For the sake of alternatives:
=COUNTA(FILTERXML("<t><s>"&SUBSTITUTE(A1,"0","</s><s>")&"</s></t>","//s[string-length(.)>2]"))
FILTERXML is available from Excel 2013 onwards (except Excel Online and Excel for Mac).
Upvotes: 3
Related Questions
- Formula in Excel to count occurrences of substrings within strings
- Count occurrences of string in a single cell in Google Sheets
- Count the strings inside an excel column
- How does one count specific individual text strings inside a range of cells, in Google Sheets?
- Count sub-strings in a cell from a range of cells (excel)
- How to count the number of times a string appears in a range of cells
- How to count cells that cointain a "string"
- How to count a keyword in a series of text strings within multiple cells in Excel?
- Counting up within a text string in Excel
- Counting values embedded in strings inside a column (Google Spreadsheets)