Count the number of times a text appears in a string

Topic Labels: Formulas
1667 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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

2 Replies 2
4 - Data Explorer
4 - Data Explorer

FIND(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: