Excel如何提取S5列前两个字的拼音大写字母?答:我把对照表直接写入公式,大火车,如图:B1单元格输入公式=LOOKUP(CODE(MID(A1,1,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","C","D","E","F","G","H","J","K","L","M","...