Count occurrences within specific cell

[Sonny_S]

Hello!

I want to look for the amount of occurences of a given string in a text column.

“Hello hello hello bye bye bye”

Would give 3

Thank you!

[Connor_McCormick]

What would “hello hello bye” give?

[Sonny_S]

Hahaha, thanks for your reply Connor.

What was I even thinking.

I clearly skipped a line in my initial request.

The counter would be for the string “hello” in that line.

So yours would give 2.

[Connor_McCormick]

Did you figure this out?

[Aurelie_Pureur]

Hey ! If you want to search just a word, I think this is working :

[Aurelie_Pureur]

And if you don’t want it to be case-sensitive you can try :