excel提取不规则字段答:=MID(A2,FIND(20,A2),FIND("号",A2)-FIND(20,A2)+1)假设,数据在A列:=MID(A:A,FIND("-",A:A,1)-5,11)B2输入=IFERROR(MID(A2,MAX(ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&(LEN(A2)-8))),9))*ROW(INDIRECT("1:"&(LEN(A2)-8)))-1,9),"")...
excel提取不规则字段答:=MID(A2,FIND(20,A2),FIND("号",A2)-FIND(20,A2)+1)假设,数据在A列:=MID(A:A,FIND("-",A:A,1)-5,11)B2输入=IFERROR(MID(A2,MAX(ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&(LEN(A2)-8))),9))*ROW(INDIRECT("1:"&(LEN(A2)-8)))-1,9),"")...