excel表格小时分钟求和答:简单一点的就用公式:=TEXT(SUMPRODUCT({-1,1}*SUBSTITUTE(SUBSTITUTE(L4:M4,"h",":"),"m",)),"[h]时m分")或者直接用小时数值的公式:=ROUND(24*SUMPRODUCT({-1,1}*SUBSTITUTE(SUBSTITUTE(L4:M4,"h",":"),"m",)),2)
excel中的哪些公式可以提取以下信息?答:B2=IFERROR(LEFT(A2,FIND("省",A2)),LEFT(A2,FIND("自治区",A2)+2))C2=IFERROR(LEFT(SUBSTITUTE(A2,B2,""),FIND("市",SUBSTITUTE(A2,B2,""))),LEFT(SUBSTITUTE(A2,B2,""),FIND("州",SUBSTITUTE(A2,B2,"")))D2=IFERROR(LEFT(SUBSTITUTE(A2,B2&C2,""),FIND("区",SUBSTITUTE(...
EXCEL里SUBSTITUTE公式的问题答:示意图如下:问题1,在这儿,用函数SUBSTITUTE不行,谁来也不可以.还不如干脆改成这样的公式:=LEFT(A2,LEN(A2)-2)问题2,你的公式是错的.改一下:=LOOKUP(9^9,--LEFT(SUBSTITUTE(D2,LEFT(D2,MIN(IF(LENB(MID(D2,ROW($1:$100),1))<>2,ROW($1:$100)))-1),""),ROW($1:$100)))...
excel中怎么在包含数字的文本中提取文本答:一、插入辅助列 B1=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,"")C1=SUBSTITUTE(SUBSTITUTE(B1,8,""),9,"")两公式向下复制。二、把excel表中的数据复制到word中,之后用word进行以下...