Excel单元格里的字母如何替换成相对应的数字答:源数据在A列,A1起,在B1输入 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"EGF",1),"CL",2),"DT",3),"FHR",4),"HSS",5),"JHR*","6*"),"JHRTYZ",7),"JMZP",8),"NLS",...
在EXCEL中如何用一个字母代替一列数中的百位数字答:=IF(--A1<100,"a"&TEXT(INT(A1),"00"),REPLACE(INT(A1),LEN(INT(A1))-2,1,CHAR(64+IF(MID(A1,LEN(INT(A1))-2,1)="0",33,MID(A1,LEN(A1)-2,1)))&SUBSTITUTE((TEXT(A1-INT(A1),".###")),".","