excel 中我想一个数字对应一个字符或字符串用什么公式?答:B2中输入 =CHAR(A1+64)就可以 补充 LOOKUP(A1,{1,2,3,...,12},{"A","B","C",...,"L"})这样可以,但不够简捷,就算是把字母都列出来,也可以写为 =mid("ABCDEFGHIJKL",A1,1)即使是 =CHOOSE(A1,"A","B","C","D","E","F","G","H","I","J","K","L")也比...
在excel中如何将字母数字组合的代号转换为纯数字答:="61"&IF(ISNUMBER(--MID(A1,1,1)),MID(A1,1,1),COLUMN(INDIRECT(MID(A1,1,1)&1)))&IF(ISNUMBER(--MID(A1,2,1)),MID(A1,2,1),COLUMN(INDIRECT(MID(A1,2,1)&1)))&IF(ISNUMBER(--MID(A1,3,1)),MID(A1,3,1),COLUMN(INDIRECT(MID(A1,...