Count number time character appears in Excel

For example, I want to get the number of times the character "s" appears in cell C21 that has text "assessment".

To do it in Excel, here is the answer:

a) Enter the formula =LEN(C21)-LEN(SUBSTITUTE(C21,"s","")) in the cell where the result is required.

The SUBSTITUTE formula removes all "s" in "Assessment" and stores the result as a string in memory. The difference in length of the original string and the length of this modified string in memory is the number of times the character

"s" appears in original string.

excel count number time character appears


You can find similar Excel Questions and Answer hereunder

1) How to find the column number from the cell address in VBA

2) How can I find the count of records that meet multiple conditions in my raw data table?

3) How do I get the rank of a number in a list of numbers?

4) How can I get the count of number of series in a Chart using VBA?

5) Our financial Year is divided into 13 periods of 4 weeks each. I enter weekly YTD data. In Excel, how can I set up Worksheet to get Period data automatically?

6) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

7) How do I have proper (Capitalize the first letter in each word of a text) text in cells ?

8) Can I apply formatting to a number concatenated with a Text?

9) How to find the cell address from the column number in VBA

10) How do I get the 2nd highest number in a range of numbers?


Here the previous and next chapter