Help

Count the number of times a text appears in a string

Topic Labels: Formulas
2076 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Juan_Gutierrez1
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.

enviar

With what function do I do this count?

Thank you very much for your support

2 Replies 2
Jonathan_Moser
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: