如何在excel中把汉字转换成拼音.docx
《如何在excel中把汉字转换成拼音.docx》由会员分享,可在线阅读,更多相关《如何在excel中把汉字转换成拼音.docx(16页珍藏版)》请在冰豆网上搜索。
![如何在excel中把汉字转换成拼音.docx](https://file1.bdocx.com/fileroot1/2023-2/3/a58815ca-8c0e-4edf-a185-fd2d7a7c5ca8/a58815ca-8c0e-4edf-a185-fd2d7a7c5ca81.gif)
如何在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="huo"
Case-17417To-17203:
pinyin="ji"
Case-17202To-17186:
pinyin="jia"
Case-17185To-16984:
pinyin="jian"
Case-16983To-16971:
pinyin="jiang"
Case-16970To-16943:
pinyin="jiao"
Case-16942To-16916:
pinyin="jie"
Case-16915To-16734:
pinyin="jin"
Case-16733To-16709:
pinyin="jing"
Case-16708To-16707:
pinyin="jiong"
Case-16706To-16690:
pinyin="jiu"
Case-16689To-16665:
pinyin="ju"
Case-16664To-16658:
pinyin="juan"
Case-16657To-16648:
pinyin="jue"
Case-16647To-16475:
pinyin="jun"
Case-16474To-16471:
pinyin="ka"
Case-16470To-16466:
pinyin="kai"
Case-16465To-16460:
pinyin="kan"
Case-16459To-16453:
pinyin="kang"
Case-16452To-16449:
pinyin="kao"
Case-16448To-16434:
pinyin="ke"
Case-16433To-16430:
pinyin="ken"
Case-16429To-16428:
pinyin="keng"
Case-16427To-16424:
pinyin="kong"
Case-16423To-16420:
pinyin="kou"
Case-16419To-16413:
pinyin="ku"
Case-16412To-16408:
pinyin="kua"
Case-16407To-16404:
pinyin="kuai"
Case-16403To-16402:
pinyin="kuan"
Case-16401To-16394:
pinyin="kuang"
Case-16393To-16221:
pinyin="kui"
Case-16220To-16217:
pinyin="kun"
Case-16216To-16213:
pinyin="kuo"
Case-16212To-16206:
pinyin="la"
Case-16205To-16203:
pinyin="lai"
Case-16202To-16188:
pinyin="lan"
Case-16187To-16181:
pinyin="lang"
Case-16180To-16172:
pinyin="lao"
Case-16171To-16170:
pinyin="le"
Case-16169To-16159:
pinyin="lei"
Case-16158To-16156:
pinyin="leng"
Case-16155To-15960:
pinyin="li"
Case-15959To-15959:
pinyin="lia"
Case-15958To-15945:
pinyin="lian"
Case-15944To-15934:
pinyin="liang"
Case-15933To-15921:
pinyin="liao"
Case-15920To-15916:
pinyin="lie"
Case-15915To-15904:
pinyin="lin"
Case-15903To-15890:
pinyin="ling"
Case-15889To-15879:
pinyin="liu"
Case-15878To-15708:
pinyin="long"
Case-15707To-15702:
pinyin="lou"
Case-15701To-15682:
pinyin="lu"
Case-15681To-15668:
pinyin="lv"
Case-15667To-15662:
pinyin="luan"
Case-15661To-15660:
pinyin="lue"
Case-15659To-15653:
pinyin="lun"
Case-15652To-15641:
pinyin="luo"
Case-15640To-15632:
pinyin="ma"
Case-15631To-15626:
pinyin="mai"
Case-15625To-15455:
pinyin="man"
Case-15454To-15449:
pinyin="mang"
Case-15448To-15437:
pinyin="mao"
Case-15436To-15436:
pinyin="me"
Case-15435To-15420:
pinyin="mei"
Case-15419To-15417:
pinyin="men"
Case-15416To-15409:
pinyin="meng"
Case-15408To-15395:
pinyin="mi"
Case-15394To-15386:
pinyin="mian"
Case-15385To-15378:
pinyin="miao"
Case-15377To-15376:
pinyin="mie"
Case-15375To-15370:
pinyin="min"
Case-15369To-15364:
pinyin="ming"
Case-15363To-15363:
pinyin="miu"
Case-15362To-15184:
pinyin="mo"
Case-15183To-15181:
pinyin="mou"
Case-15180To-15166:
pinyin="mu"
Case-15165To-15159:
pinyin="na"
Case-15158To-15154:
pinyin="nai"
Case-15153To-15151:
pinyin="nan"
Case-15150To-15150:
pinyin="nang"
Case-15149To-15145:
pinyin="nao"
Case-15144To-15144:
pinyin="ne"
Case-15143To-15142:
pinyin="nei"
Case-15141To-15141:
pinyin="nen"
Case-15140To-15140:
pinyin="neng"
Case-15139To-15129:
pinyin="ni"
Case-15128To-15122:
pinyin="nian"
Case-15121To-15120:
pinyin="niang"
Case-15119To-15118:
pinyin="niao"
Case-15117To-15111:
pinyin="nie"
Case-15110To-15110:
pinyin="nin"
Case-15109To-14942:
pinyin="ning"
Case-14941To-14938:
pinyin="niu"
Case-14937To-14934:
pinyin="nong"
Case-14933To-14931:
pinyin="nu"
Case-14930To-14930:
pinyin="nv"
Case-14929To-14929:
pinyin="nuan"
Case-14928To-14927:
pinyin="nue"
Case-14926To-14923:
pinyin="nuo"
Case-14922To-14922:
pinyin="o"
Case-14921To-14915:
pinyin="ou"
Case-14914To-14909:
pinyin="pa"
Case-14908To-14903:
pinyin="pai"
Case-14902To-14895:
pinyin="pan"
Case-14894To-14890:
pinyin="pang"
Case-14889To-14883:
pinyin="pao"
Case-14882To-14874:
pinyin="pei"
Case-14873To-14872:
pinyin="pen"
Case-14871To-14858:
pinyin="peng"
Case-14857To-14679:
pinyin="pi"
Case-14678To-14675:
pinyin="pian"
Case-14674To-14671:
pinyin="piao"
Case-14670To-14669:
pinyin="pie"
Case-14668To-14664:
pinyin="pin"
Case-14663To-14655:
pinyin="ping"
Case-14654To-14646:
pinyin="po"
Case-14645To-14631:
pinyin="pu"
Case-14630To-14595:
pinyin="qi"
Case-14594To-14430:
pinyin="qia"
Case-14429To-14408:
pinyin="qian"
Case-14407To-14400:
pinyin="qiang"
Case-14399To-14385:
pinyin="qiao"
Case-14384To-14380:
pinyin="qie"
Case-14379To-14369:
pinyin="qin"
Case-14368