问题描述： 如何应用Excel函数把汉字换成拼音首字母 1个回答 分类：综合 2014-09-26 问题解答： 我来补答 如A1－A50输入的是汉字.则在B1中的公式为：=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"})B2－B50填充. 展开全文阅读
