Excel函数判定一单元格内其中一个数据被另一单元格包含?答:),ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1))*199-198,199)),TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",199)),ROW(INDIRECT("1:"&LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1))*199-198,199)),)),"包含","不包含")同时按Ctrl+Shift+Enter三键输入数组公式 ...