更新时间2018-11-29 09:03:45
假如我A列单元格里面有墙,则提取墙在B列里面, 有柱则提取柱。谢谢!
=IFERROR(MID(A1,IFERROR(FIND("柱",A1),0)+IFERROR(FIND("板",A1),0)+IFERROR(FIND("墙",A1),0)+IFERROR(FIND("梁",A1),0),1),"")
=IF(ISERROR(FIND("柱",A1),"柱","")
+IF(ISERROR(FIND("板",A1),"板","")
+IF(ISERROR(FIND("梁",A1),"梁","")