Search for repeated alphabet in a string (column)

Hello,

I would like to know if there's any method to count the repeat alphabet in a string. 

For example, I want to get "a" from a column, repeat for how many times. Is there a way to do it? Thank you.