Search for word in a string of data

Hi

I have put a formula in excel to count how many times the word 'administration' appears in a column:

=COUNTIF(K2:K99,"Administration")

Unfortunately, the output that I am searching has mulitple words in it, separated with a colon and no space. My formula skips the count if the word Administration is not completely on it's own

e.g. Administration counts 1
Administration;Cardiology does not count

Could anyone help me to adjust my formula to look for the word Administration if it is amongst other words?

Thank you in advance

Hi,

Try this:

=COUNTIF(K2:K99,"*Administration*")