count number time character appears in Excel

Q13. Can I determine the number of times a character appears in a cell using formula?

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) Find and count instances of a character in a string in Excel

2) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?

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

4) Concatenate number with text but keeping in number format in Excel

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

6) How can I fill a range of cells with incremental times?

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

8) How do I change the rating numbers to rating labels?

9) How to do date and time zone conversion in excel in Excel

10) How can I find the count of records that meet a given condition in my raw data table?

11) How can I generate random numbers between 2 limits?

12) How can I get row count of filtered data?

13) How can I execute an event at a predetermined time from my Macro?

14) How can I convert Column numbers into Column names for use in range definition?

15) 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?