在excel中把汉字转换成拼音扩充加强版

《在excel中把汉字转换成拼音扩充加强版》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、网上有很多类似的方法，但是因为字库很少，一些常用的汉字都无法转换，比如是“倩”“窦”等等，本人本着坚持不懈的态度将这些字补充进去，便于后来人使用。1.启动Excel2003（其它版本请仿照操作），打开相应的工作表；2.执行“工具→宏→VisualBasic编辑器”命令（或者直接按“Alt+F11”组合键），进入VisualBasic编辑状态；3.执行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态；4.将代码输入其中；Functionpinyin(pAsString)AsStringi=Asc(p)SelectCaseiCase-20319

2、To-20318:pinyin="a"Case-20317To-20305:pinyin="ai"Case-20304To-20296:pinyin="an"Case-20295To-20293:pinyin="ang"Case-20292To-20284:pinyin="ao"Case-20283To-20266:pinyin="ba"Case-20265To-20258:pinyin="bai"Case-20257To-20243:pinyin="ban"Case-20242To-20231:pinyin="bang"Case-20230To-20052:pin

3、yin="bao"Case-20051To-20037:pinyin="bei"Case-20036To-20033:pinyin="ben"Case-20032To-20027:pinyin="beng"Case-20026To-20003:pinyin="bi"Case-20002To-19991:pinyin="bian"Case-19990To-19987:pinyin="biao"Case-19986To-19983:pinyin="bie"Case-19982To-19977:pinyin="bin"Case-19976To-19806:pinyin="

4、bing"Case-19805To-19785:pinyin="bo"Case-19784To-19776:pinyin="bu"Case-19775To-19775:pinyin="ca"Case-19774To-19764:pinyin="cai"Case-19763To-19757:pinyin="can"Case-19756To-19752:pinyin="cang"Case-19751To-19747:pinyin="cao"Case-19746To-19742:pinyin="ce"Case-19741To-19740:pinyin="ceng"Case

5、-19739To-19729:pinyin="cha"Case-19728To-19726:pinyin="chai"Case-19725To-19716:pinyin="chan"Case-19715To-19541:pinyin="chang"Case-19540To-19532:pinyin="chao"Case-19531To-19526:pinyin="che"Case-19525To-19516:pinyin="chen"Case-19515To-19501:pinyin="cheng"Case-19500To-19485:pinyin="chi"Cas

6、e-19484To-19480:pinyin="chong"Case-19479To-19468:pinyin="chou"Case-19467To-19290:pinyin="chu"Case-19289To-19289:pinyin="chuai"Case-19288To-19282:pinyin="chuan"Case-19281To-19276:pinyin="chuang"Case-19275To-19271:pinyin="chui"Case-19270To-19264:pinyin="chun"Case-19263To-19262:pinyin="ch

7、uo"Case-19261To-19250:pinyin="ci"Case-19249To-19244:pinyin="cong"Case-19243To-19243:pinyin="cou"Case-19242To-19239:pinyin="cu"Case-19238To-19236:pinyin="cuan"Case-19235To-19228:pinyin="cui"Case-19227To-19225:pinyin="cun"Case-19224To-19219:pinyin="cuo"Case-19218To-19213:pinyin="da"Cas