Count occurrences within specific cell


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?