excel提取2个关键字符中间的数字?答:如图,在天、小时、分钟单元格依次输入公式 =IF(ISERR(FIND("天",A72)),0,LEFT(A72,FIND("天",A72)-1))=IF(ISERR(FIND("小时",A72)),0,MID(A72,IF(ISERROR(FIND("天",A72)),0,FIND("天",A72))+1,FIND("小时",A72)-IF(ISERROR(FIND("天",A72)),0,FIND("天",A72))-1))...
使用excel提取特定字符中间的数字?答:=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(A:A)*100-99,100))右拉填充,下拉填充 如果只取第二个/和第三个/中间的 11 这个数字,可用如下公式 =TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(C:C)*100-99,100))或 =TRIM(MID(SUBSTITUTE($A1,"/",REPT(" "...