EXCEL如何实现字母数字递增,如A0000005262350最后一位依次到9后变为A...答:方案二:任意单元格公式:="A0000005262"&CHOOSE(MOD(INT(9039/16^2+ROW(A1)/16^2),16)+1,0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F")&CHOOSE(MOD(INT(9039/16+ROW(A1)/16),16)+1,0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F")&CHOOSE(MOD...