【急求】find函数能实现多条件的查找吗？

B1输入
=IF(COUNT(FIND({"颈","肩","腿","腰","手","背"},A1)),MID(A1,MIN(IF(ISERROR(FIND({"颈","肩","腿","腰","手","背"},A1)),4^8,FIND({"颈","肩","腿","腰","手","背"},A1))),FIND("痛",A1)-MIN(IF(ISERROR(FIND({"颈","肩","腿","腰","手","背"},A1)),4^8,FIND({"颈","肩","腿","腰","手","背"},A1)))+1),"")
回车并向下填充。

（公式很拗口！）
Stcxj@126.com

在B1输入公式
=MID($A$1,SMALL(IF(ISERROR(FIND({"颈";"肩";"腿";"腰";"手";"背"},$A$1)),4^8,FIND({"颈";"肩";"腿";"腰";"手";"背"},$A$1)),ROW(1:6)),FIND("痛",$A$1,SMALL(IF(ISERROR(FIND({"颈";"肩";"腿";"腰";"手";"背"},$A$1)),4^8,FIND({"颈";"肩";"腿";"腰";"手";"背"},$A$1)),ROW(1:6)))+1-SMALL(IF(ISERROR(FIND({"颈";"肩";"腿";"腰";"手";"背"},$A$1)),4^8,FIND({"颈";"肩";"腿";"腰";"手";"背"},$A$1)),ROW(1:6)))
然后选中B1到B6，按F2，然后按Ctrl+Shift+Enter。