如何在excel中把汉字转换成拼音.doc

《如何在excel中把汉字转换成拼音.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、......Excel自定义函数方法：　　1.启动Excel2003（其它版本请仿照操作），打开相应的工作表；　　2.执行“工具→宏→VisualBasic编辑器”命令（或者直接按“Alt+F11”组合键），进入VisualBasic编辑状态；　　3.执行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态；　　4.将代码输入其中；　　5.代码输入完成后，关闭VisualBasic编辑窗口，返回Excel编辑状态；6.自定义函数就可以用了，如：选中D2单元格，输入公式：=getpy(A2)。有极个别的汉字不能转

2、换，手动就可以了！很方便了。Functionpinyin(pAsString)AsStringi=Asc(p)SelectCaseiCase-20319To-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:piny

3、in="bai"Case-20257To-20243:pinyin="ban".专业.专注.......Case-20242To-20231:pinyin="bang"Case-20230To-20052:pinyin="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="bia

4、n"Case-19990To-19987:pinyin="biao"Case-19986To-19983:pinyin="bie"Case-19982To-19977:pinyin="bin"Case-19976To-19806:pinyin="bing"Case-19805To-19785:pinyin="bo"Case-19784To-19776:pinyin="bu"Case-19775To-19775:pinyin="ca"Case-19774To-19764:pinyin="cai"Case-19763To-19757:p

5、inyin="can"Case-19756To-19752:pinyin="cang"Case-19751To-19747:pinyin="cao"Case-19746To-19742:pinyin="ce"Case-19741To-19740:pinyin="ceng"Case-19739To-19729:pinyin="cha"Case-19728To-19726:pinyin="chai".专业.专注.......Case-19725To-19716:pinyin="chan"Case-19715To-19541:pinyin

6、="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"Case-19484To-19480:pinyin="chong"Case-19479To-19468:pinyin="chou"Case-19467To-19290:pinyin="chu"Case-1

7、9289To-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="chuo"Case-19261To-19250:pinyin="ci"Case-19249To-19244:pinyin="cong"Case-19243To-1924

8、3:pinyin="cou"Case-19242To-19239:pinyin="cu"Case-19238To-19236:pinyin="cuan"Case-19235To-19228:pinyin="cui".专业.专注....