Question: How do I count how many times a text string occurs in a cell in excel?

Answer:

Formula in B5:

=(LEN(B1)-LEN(SUBSTITUTE(B1, B3, "")))/LEN(B3)

Functions in this article:

Len(text)
Returns the number of characters in a text string

Substitute(text, old_text, new_text, [instance_num])
Replaces existing text with new text in a text string

This blog article is one out of three articles on the same subject.

• Count number of times a string exist in multiple cells using excel formula
• Count text that occurs multiple times in excel cell
• Count occurences of a specific text string in a column in excel

Read more related articles in the archive.

Related posts:

1. Count occurences of a specific text string in a column in excel
2. Count number of times a string exist in multiple cells using excel formula
3. Lookup with multiple criteria and display multiple search results using excel formula, part 2
4. Lookup with multiple criteria and display multiple search results using excel formula
5. Search for multiple text strings in multiple cells in excel
6. Lookup with multiple criteria and display multiple search results using excel formula, part 3
7. Lookup with multiple criteria and display multiple search results using excel formula, part 4
8. Search for multiple text strings in multiple cells in excel, part 2
9. Search for a cell value in an excel table