Excel: How To Count How Many Times A Specific Character Appears In A Cell

Counting the Number of Times a Specific Character Appears In A Cell..

This will count how many times the letter ‘a’ appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”a“,””))

This will count how many times the character ‘,’ (a comma) appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”,“,””))… Read the rest

Counting the Number of Times a Specific Character Appears In A Cell..

This will count how many times the letter ‘a’ appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”a“,””))

This will count how many times the character ‘,’ (a comma) appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”,“,””))… Read the rest