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. Lookup with multiple criteria and display multiple search results using excel formula, part 4
2. Search for multiple text strings in multiple cells and use in data validation in excel
3. Count matching cell values in two columns in excel
4. Count unique distinct text values in a range in excel
5. Count unique text values in a range containing both numerical and text values