# 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 *A**1**)*.

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.