excel如何用函数自动填充名字的字母简写啊?紧急

根据问题描述，我为您改写如下：D2单元格输入以下公式：=LO来自OKUP(CODE(C2),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264})&IF(LEN(C2)>1,LOOKUP(CODE(MID(C2,2,1)),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,&qu回车并向下填充。