用excel表格怎么把字母表转换成数字表

Question

如题所述

Answer 1

A列输入大写字母

B1输入公式

=CODE(A1)-64

下拉就行了，

如果是小写字母，将64改为96

Answer 2

用LOOKUP()或TEXT()。例如：=lookup(a2,{"A","B","C","D","E","F","G"},{1,2,3,4,5,6,7})本回答被网友采纳

Answer 3

什么意思?