Count specific characters in EXCEL cell

Find the number of occurrences of a specific Letter or any symbol in an EXCEL cell.

will Determine how many letters Z in the word Zigzag (the word is in the cell A1).

Formula for calculation of symbol Z in the word Zigzag (case-sensitive), see sample file:
=LEN(A1) - LEN(SUBSTITUTE(A1,"Z",""))

Formula for calculation of Z (or z) in the word Zigzag (case-insensitive):
=LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),"z",""))

To count the number of spaces (character code of a space is 32) in a cell use the formula:
=LEN(A1) - LEN(SUBSTITUTE(A1,CHAR(32),""))

the article Count the number of occurrences of a sequence of characters shows how to count the number of occurrences of a certain sequence of characters in a text string.

About the search position of the n-th occurrence of letter in a word or text line can be read here.