EXCEL如何实现字母数字递增,如A0000005262350最后一位依次到9后变为A...答:="A00000052"&CHOOSE(MOD(INT(402255/16^4+ROW(A1)/16^4),16)+1,0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F")&CHOOSE(MOD(INT(402255/16^3+ROW(A1)/16^3),16)+1,0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F")&CHOOSE(MOD(INT(402255/16...