如何在excel中把汉字转换成拼音.docx
- 文档编号:2327910
- 上传时间:2022-10-28
- 格式:DOCX
- 页数:14
- 大小:18.35KB
如何在excel中把汉字转换成拼音.docx
《如何在excel中把汉字转换成拼音.docx》由会员分享,可在线阅读,更多相关《如何在excel中把汉字转换成拼音.docx(14页珍藏版)》请在冰豆网上搜索。
如何在excel中把汉字转换成拼音
Excel自定义函数方法:
1.启动Excel2003(其它版本请仿照操作),打开相应的工作表;
2.执行“工具→宏→VisualBasic编辑器”命令(或者直接按“Alt+F11”组合键),进入VisualBasic编辑状态;
3.执行“插入→模块”命令,插入一个新模块。
再双击插入的模块,进入模块代码编辑状态;
4.将代码输入其中;
5.代码输入完成后,关闭VisualBasic编辑窗口,返回Excel编辑状态;
6.自定义函数就可以用了,如:
选中D2单元格,输入公式:
=getpy(A2)。
有极个别的汉字不能转换,手动就可以了!
很方便了。
Functionpinyin(pAsString)AsString
i=Asc(p)
SelectCasei
Case-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:
pinyin="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="bian"
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:
pinyin="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="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-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="chuo"
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"
Case-19212To-19039:
pinyin="dai"
Case-19038To-19024:
pinyin="dan"
Case-19023To-19019:
pinyin="dang"
Case-19018To-19007:
pinyin="dao"
Case-19006To-19004:
pinyin="de"
Case-19003To-18997:
pinyin="deng"
Case-18996To-18978:
pinyin="di"
Case-18977To-18962:
pinyin="dian"
Case-18961To-18953:
pinyin="diao"
Case-18952To-18784:
pinyin="die"
Case-18783To-18775:
pinyin="ding"
Case-18774To-18774:
pinyin="diu"
Case-18773To-18527:
pinyin="dong"
Case-18526To-18519:
pinyin="fa"
Case-18518To-18502:
pinyin="fan"
Case-18501To-18491:
pinyin="fang"
Case-18490To-18479:
pinyin="fei"
Case-18478To-18464:
pinyin="fen"
Case-18463To-18449:
pinyin="feng"
Case-18448To-18448:
pinyin="fo"
Case-18447To-18447:
pinyin="fou"
Case-18446To-18240:
pinyin="fu"
Case-18239To-18238:
pinyin="ga"
Case-18237To-18232:
pinyin="gai"
Case-18231To-18221:
pinyin="gan"
Case-18220To-18212:
pinyin="gang"
Case-18211To-18202:
pinyin="gao"
Case-18201To-18185:
pinyin="ge"
Case-18184To-18184:
pinyin="gei"
Case-18183To-18182:
pinyin="gen"
Case-18181To-18013:
pinyin="geng"
Case-18012To-17998:
pinyin="gong"
Case-17997To-17989:
pinyin="gou"
Case-17988To-17971:
pinyin="gu"
Case-17970To-17965:
pinyin="gua"
Case-17964To-17962:
pinyin="guai"
Case-17961To-17951:
pinyin="guan"
Case-17950To-17948:
pinyin="guang"
Case-17947To-17932:
pinyin="gui"
Case-17931To-17929:
pinyin="gun"
Case-17928To-17923:
pinyin="guo"
Case-17922To-17760:
pinyin="ha"
Case-17759To-17753:
pinyin="hai"
Case-17752To-17734:
pinyin="han"
Case-17733To-17731:
pinyin="hang"
Case-17730To-17722:
pinyin="hao"
Case-17721To-17704:
pinyin="he"
Case-17703To-17702:
pinyin="hei"
Case-17701To-17698:
pinyin="hen"
Case-17697To-17693:
pinyin="heng"
Case-17692To-17684:
pinyin="hong"
Case-17683To-17677:
pinyin="hou"
Case-17676To-17497:
pinyin="hu"
Case-17496To-17488:
pinyin="hua"
Case-17487To-17483:
pinyin="huai"
Case-17482To-17469:
pinyin="huan"
Case-17468To-17455:
pinyin="huang"
Case-17454To-17434:
pinyin="hui"
Case-17433To-17428:
pinyin="hun"
Case-17427To-17418:
pinyin
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 如何 excel 汉字 转换 拼音