Filter Exact word from Columns having No. of strings VBA

[Jasvindra]

I am using below criteria to search exact string out of a column of string


sCriteria = "*" & " " & Range("H" & i).Value & " " & "*"


But it only picks up the word that is preceded and followed by a word.Even if I add space at the start and end of string.

Is there any way