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:


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


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

Random image

A rumored leaked Sim City 5 screenshot, exact origin is unknown;  the exact release date for Sim City 5 is not yet announced