Excel Help: Count Matches to (in) a String

Use the following formula if you want to match how many times a particular string (substring actually) occurs in a cell:

=(LEN(A1)-LEN(SUBSTITUTE(A1,"matchthis","")))/LEN("matchthis")

You will of course need to replace "matchthis" with whatever string you want to count. This formula takes in A1 as the input so you may want to change that as well.

If you like this formula, tell your friends!