Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 26, 2021 06:38 PM
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
Jan 27, 2021 08:32 PM
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
Jan 28, 2021 04:48 PM
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: