C1公式
=IF(SUMPRODUCT(--ISNUMBER(FIND(MID(A1&REPT(" ",100),ROW(1:10)*3-2,2),B1)))=LEN(SUBSTITUTE(A1," ",""))/2,"是","")
或者
=RIGHT("不包含",3-(SUMPRODUCT(--ISNUMBER(FIND(MID(A1&REPT(" ",100),ROW(1:10)*3-2,2),B1)))=LEN(SUBSTITUTE(A1," ",""))/2))
=if(find(a1,b1,1)>0,"是","")
C1公式
=if(isnumber(find(b1,a1)),b1,"")
即可
答:菜单栏。