Hello, I have a text string of which I need to know how many times a word appears.
For this example “Enviar” appears 3 times and “Pendiente” 4.
With what function do I do this count?
Thank you very much for your support
Count the number of times a text appears in a string
+6FIND(stringToFind, whereToSearch,[startFromPosition])
Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0.
Similar to SEARCH(), though SEARCH() returns empty rather than 0 if no occurrence of stringToFind is found.
FIND(“fox”, “quick brown fox”)
=> 13
+6FIND(stringToFind, whereToSearch,[startFromPosition])
Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0.
Similar to SEARCH(), though SEARCH() returns empty rather than 0 if no occurrence of stringToFind is found.
FIND(“fox”, “quick brown fox”)
=> 13
Thank you very much for your help
I already tried it but it only works when it is a single text not to count in the whole string the times that the same text appears. :frowning:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.