FYI, I figured it out:

=LEN(cell_ref)-LEN(SUBSTITUTE(cell_ref,"character",""))




"Henrik" wrote:

I meant to say:

Does anyone know a way to automatically count how many times a certain
character appears in a text string?

(i.e. "w" appears 3 times in the string above)




"Henrik" wrote:

Does anyone know a way to automatically count how many times a certain
character counts in a text string?