Count the number of times a text appears in a string

[Juan_Gutierrez1]

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

[Jonathan_Moser]

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

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...

[Juan_Gutierrez1]

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: