excel公式编写求助,大神请进,谢谢。答:C2公式:=CHAR(FIND(MID(B2,1,1),B2)+64)&CHAR(FIND(MID(B2,2,1),B2)+64)&CHAR(FIND(MID(B2,3,1),B2)+64)&CHAR(FIND(MID(B2,4,1),B2)+64)&CHAR(FIND(MID(B2,5,1),B2)+64)D2公式:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(...
在excel中如何将三十六转化为36?答:只有进行剥洋葱皮式的替换了,假如数据在A列并从A1开始,在B1单元格输入公式=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(LEN(A1)=1,SUBSTITUTE(A1,"十",10),IF(LEN(A1)=2,SUBSTITUTE(A1,"十",0),A1)),"一",1),"二",2),"...
excel中如何将四个“|”替换成ABCD答:假设答案在A1单元格,形式为:|123|234|345|3456,则公式为:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|","A、",1),"|"," B、",1),"|"," C、",1),"|"," D、")如形式为:123|234|345|3456,则公式为:="A、"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|"," B、",1...
excel中,用月数算出多少年多少月。答:2、如果A1输入带单位的数据,比如“73个月”,上面公式改为:=IF(--SUBSTITUTE(A2,"个月","")<12,A2,"")&"个月",IF(MOD(SUBSTITUTE(A2,"个月",""),12)=0,SUBSTITUTE(A2,"个月","")/12&"年",ROUNDDOWN(SUBSTITUTE(A2,"个月","")/12,0)&"年"&MOD(SUBSTITUTE(A2,"个月",""...