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?:

Random image

Who doesn't want a pet frog?