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

Answer:

text-string-occurences

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.

Read more related articles in the archive.

  • Share/Bookmark

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