excel 中怎么样把汉字转换成英文简称

来源：百度知道 编辑：UC知道 时间：2024/05/05 01:33:12
如题,例如A1里是"阿莫西林",用什么函数可以让B1自动显示"AMXL",是每个字第一个英文,求高手指导下呀!

借用其他高手的回答：（以下公式为四个汉字内，再多还要加公式）
=LOOKUP(CODE(A1),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})&IF(LEN(A1)>1,LOOKUP(CODE(MID(A1,2,1)),45217+{-45185,0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"","A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})