如何应用Excel函数把汉字换成拼音首字母

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/11 20:28:16

如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填充.

如何应用Excel函数把汉字换成拼音首字母如何把Excel中的拼音变成汉字 excel中如何实现提取汉字的拼音首字母? excel中如何实现提取汉字的拼音首字母？把英文,汉字换成拼音请问越南人干嘛把汉字换成拼音了. 请问Excel 中怎么把姓名按拼音首字母排序? excel表格中如何自动填写拼音首字母缩写怎样在excel表格中把汉字变成拼音如何将EXCEL表格中的汉字转为拼音如何把汉字转换成拼音 excel函数公式应用