excel 怎么提取包含特定字段的字符串答:B1输入 =IF(COUNTIF(A1,"*abcd*"),TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),99*MAX(NOT(ISERR(FIND("abcd",MID(SUBSTITUTE(A1," ",REPT(" ",99)),99*ROW($1:$99)-98,99)))*ROW($1:$99))-98,99)),"")按【CTRL+SHIFT+回车】后,下拉填充公式即可。如果要用VBA的话,...
excel中取某个字符之间的字符串答:假设要提取的数据在A1,B1中输入公式:=-TRIM(-MID(SUBSTITUTE(MID($A1,FIND("/",$A1)+1,FIND("L",$A1)-FIND("/",$A1)-1),"*",REPT(" ",99)),COLUMN(A:A)*99-98,99))右拉到C1
Excel中如何提取两个字符中间的字符串答:=MID(B2,FIND(".",SUBSTITUTE(B2,".",0,1))+1,FIND(".",SUBSTITUTE(SUBSTITUTE(B2,".",0,1),".",0,1))-FIND(".",SUBSTITUTE(B2,".",0,1))-1)