Formula help to count specific characters?

Hi community! I’m creating a content calendar and would love to be able to count how many hashtags are in the Post Hashtags column in the same row. I’ve tried what I feel like is every option but can’t figure out how to count the instances of just that one character. Alternatively counting the words or the unique words might also work. Any thoughts? Here is an example of the table:


Hey @Heather_Hart ,
there might be several ways, but my quickest solution was just to use “Split” for splitting up the hashtags by the char “#” and then count the result/list.

Hope that helps :slight_smile:



Here is another one:

These are both so helpful. Thanks to you both @Daniel_Stieber and @joost_mineur!!