I would have suggested that clean up.. but usually I am met with the response, that "I don't have control over that setup"... so I basically worked around it...

But if you do clean it up to that point, then we can get rid of a the Substitute() functions and reduce it to:

=SUMPRODUCT(--(ISNUMBER(SEARCH(" "&$B$2:$B$68&" "," "&TRIM(F2)&" "))),$A$2:$A$68)