excel如何提取单元格内多行文字中包含某关键字的整行文字?答:B1输入:=MID(A1,FIND("螺丝,",A1),FIND("个",A1,FIND("螺丝,",A1))-FIND("螺丝,",A1)+1)注意下螺丝后面的逗号,看来原来像是中文逗号。另外,如果不是每个单元格都有,防止出现错误值:07版后用:=IFERROR(MID(A1,FIND("螺丝,",A1),FIND("个",A1,FIND("螺丝,",A1))-FIND(...
excel如何提取单元格内多行文字中包含某关键字的整行文字?答:B1输入:=MID(A1,FIND("螺丝,",A1),FIND("个",A1,FIND("螺丝,",A1))-FIND("螺丝,",A1)+1)注意下螺丝后面的逗号,看来原来像是中文逗号。另外,如果不是每个单元格都有,防止出现错误值:07版后用:=IFERROR(MID(A1,FIND("螺丝,",A1),FIND("个",A1,FIND("螺丝,",A1))-FIND(...