Count specific characters in text string

1 Users


2 Highlights

0 Notes


Top Highlights

  • The idea is to calculate the length of the original text string, then subtract the length of the text string after removing all occurrences of the character

  • This formula counts the number of a's that appear in cell B5. Notice the LEN function is used twice

Ready to highlight and find good content?

Glasp is a social web highlighter that people can highlight and organize quotes and thoughts from the web, and access other like-minded people’s learning.