the operator is "Like"

* = none or many characters
? = exactly one char

"toto" Like "*ot*" is true

find more details in the vba help, but the idea is to use
T$ Like "*wanted*"

and this will be true since wanted is include in T