Count specific characters in text string
exceljet.net/formulas/count-specific-characters-in-text-string
1 Users
0 Comments
2 Highlights
0 Notes
Tags
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.