Count occurrences within specific cell

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!

What would “hello hello bye” give?

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.

Did you figure this out?

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

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