如何在excel中把汉字转换成拼音.docx
《如何在excel中把汉字转换成拼音.docx》由会员分享,可在线阅读,更多相关《如何在excel中把汉字转换成拼音.docx(22页珍藏版)》请在冰豆网上搜索。
如何在excel中把汉字转换成拼音
Excel自定义函数方法:
1.启动Excel2003(其它版本请仿照操作),打开相应的工作表;
2.执行“工具t宏tVisualBasic编辑器”命令(或者直接按“Alt+F11”组合键),
进入VisualBasic编辑状态;
3.执行“插入t模块”命令,插入一个新模块。
再双击插入的模块,进入模块代码编辑状态;
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=
="Ian"
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"