Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Count the number of times a text appears in a string

Topic Labels: Formulas
597 2
Showing results for 
Search instead for 
Did you mean: 

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

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: