Perhaps in C1 something like =if(isnumber(search("*"&B1&"*",$A$1)),"contained","not contained") and pull down as needed