excel里截取某两个特定字符转中间的 数据答:设文本所在单元格为:A1 在其他单元内输入或粘贴:=MID(A1,FIND("type=",A1)+6,FIND("process_name=",A1)-(FIND("type=",A1)+6)-2)&" "&MID(A1,FIND("process_name=",A1)+14,FIND("times=",A1)-(FIND("process_name=",A1)+14)-2)&" "&MID(A1,FIND("times=",A1)+7,...
excel提取2个关键字符中间的数字?答:=MID(A1,FIND("#",SUBSTITUTE(A1,"\","#",LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))+1,FIND("_",A1)-FIND("#",SUBSTITUTE(A1,"\","#",LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))-1)