Navigation

User login

To prevent automated spam submissions leave this field empty.

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!

by Margaret Walker on Wed, 06/16/2010 - 20:37

Recent Posts

Poll

Are you excited for Avatar 2?
I already dyed my skin blue in anticipation!
44%
I think I'll wait for the reviews
32%
I prefer movies about puppies and kittens!
24%
Total votes: 5971

Random image

The location of Denmark on a map