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

To count the number of Xs in s, try

=LEN(s)-LEN(SUBSTITUTE(s,"X",""))