excel中怎么把四个不固定的字母转换成数字?

发布网友发布时间：2022-12-31 15:05

共1个回答

热心网友时间：2023-11-10 00:03

每个字母用Vlookup查，参照下图，自己把……按样子补充完整
d2=vlookup(mid(c2,1,1),{"0","1",...,"A","B",...,"M"},{0,1,...,10,...,21},2,0)&vlookup(mid(c2,2,1),{"0","1",...,"A","B",...,"M"},{0,1,...,10,...,21},2,0)&vlookup(mid(c2,3,1),{"0","1",...,"A","B",...,"M"},{0,1,...,10,...,21},2,0)

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com