电子表格如何用Excel函数非常快的录入26个英文字母?

1.如何用Excel函数非常快的录入26个英文字母?

用函数转换来实现26个英文字母的自动填充：

如果从A2开始向下输入“A、B、C……”，先在A2单元格中输入公式=CHAR(65+ROW()-2），然后用“填充柄”向下拖拉即可；如果从B2开始向右输入“A、B、C……”，先在B2单元格中输入公式=CHAR(65+COLUMN()-2），然后用“填充柄”向右拖拉即可。

注意：

①如果需要输入小写字母序列，只要将上述两个公式分别修改一下就好了：=CHAR(97+ROW()-2）、=CHAR(97+COLUMN()-2)

②也可以将字母做成内置序列，同样可以快速输入。

2.EXCEL如何把数字定义成某个英文字母

数据输入在a1，比如 重

b1输入

="%"&LOOKUP(INT(CODE(A1) /4096),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})&LOOKUP(INT(MOD(CODE(A1),4096)/256),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})&LOOKUP(INT(MOD(MOD(CODE(A1),4096),256)/16),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})&LOOKUP(MOD(MOD(MOD(CODE(A1),4096),256),16),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})

结果是 %D6D8

其实就是10进制转换为16进制了

我知道可以用函数，上面是我做的例子，不转换16进制 转换任意进制用我的方法都ok,excel提供的只能转换2,8,16进制，15进制还能转换么？