excel2020汉字转拼音的方法步骤.docx

《excel2020汉字转拼音的方法步骤.docx》由会员分享，可在线阅读，更多相关《excel2020汉字转拼音的方法步骤.docx（29页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、excel2020汉字转拼音的方法步骤excel2020汉字转拼音的方法步骤在Excel中录入好数据以后可能会有需要把汉字转拼音的需求，或许有的朋友并不知道该怎样汉字转拼音，假如不懂的朋友欢迎一起来探究学习。下面是学习啦我带来的关于excel2020汉字转拼音的方法，希望浏览过后对你有所启发!excel2020汉字转拼音的方法1汉字转拼音步骤1：打开你的Excel文件，按Alt+F11打开VBA编辑窗口，然后在左侧空白处点击右键，插入，模块。右侧空白处粘贴下面的代码。关闭VBA窗口。汉字转拼音步骤2：代码太长，超字数限制了，请从这里下载：pan.baidu/s/1bnCn9fD汉字转拼音步骤3

2、：然后在需要的地方输入公式：=PINYIN(单元格地址)即可。汉字转拼音步骤4：如下列图，在B1输入：=PINYIN(A1)excel2020汉字转拼音的方法2汉字转拼音步骤1：启动Excel2020(其它版本请仿照操作)，打开相应的工作表;汉字转拼音步骤2：执行工具宏VisualBasic编辑器命令(或者直接按Alt+F11组合键)，进入VisualBasic编辑状态;汉字转拼音步骤3：执行插入模块命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态;汉字转拼音步骤4：将代码输入其中;Functionpinyin(pAsString)AsStringi=Asc(p)SelectCas

3、eiCase-20319To-20318:pinyin=aCase-20317To-20305:pinyin=aiCase-20304To-20296:pinyin=anCase-20295To-20293:pinyin=angCase-20292To-20284:pinyin=aoCase-20283To-20266:pinyin=baCase-20265To-20258:pinyin=baiCase-20257To-20243:pinyin=banCase-20242To-20231:pinyin=bangCase-20230To-20052:pinyin=baoCase-20051To-

4、20037:pinyin=beiCase-20036To-20033:pinyin=benCase-20032To-20027:pinyin=bengCase-20026To-20003:pinyin=biCase-20002To-19991:pinyin=bianCase-19990To-19987:pinyin=biaoCase-19986To-19983:pinyin=bieCase-19982To-19977:pinyin=binCase-19976To-19806:pinyin=bingCase-19805To-19785:pinyin=boCase-19784To-19776:pi

5、nyin=buCase-19775To-19775:pinyin=caCase-19774To-19764:pinyin=caiCase-19763To-19757:pinyin=canCase-19756To-19752:pinyin=cangCase-19751To-19747:pinyin=caoCase-19746To-19742:pinyin=ceCase-19741To-19740:pinyin=cengCase-19739To-19729:pinyin=chaCase-19728To-19726:pinyin=chaiCase-19725To-19716:pinyin=chanC

6、ase-19715To-19541:pinyin=changCase-19540To-19532:pinyin=chaoCase-19531To-19526:pinyin=cheCase-19525To-19516:pinyin=chenCase-19515To-19501:pinyin=chengCase-19500To-19485:pinyin=chiCase-19484To-19480:pinyin=chongCase-19479To-19468:pinyin=chouCase-19467To-19290:pinyin=chuCase-19289To-19289:pinyin=chuai

7、Case-19288To-19282:pinyin=chuanCase-19281To-19276:pinyin=chuangCase-19275To-19271:pinyin=chuiCase-19270To-19264:pinyin=chunCase-19263To-19262:pinyin=chuoCase-19261To-19250:pinyin=ciCase-19249To-19244:pinyin=congCase-19243To-19243:pinyin=couCase-19242To-19239:pinyin=cuCase-19238To-19236:pinyin=cuanCa

8、se-19235To-19228:pinyin=cuiCase-19227To-19225:pinyin=cunCase-19224To-19219:pinyin=cuoCase-19218To-19213:pinyin=daCase-19212To-19039:pinyin=daiCase-19038To-19024:pinyin=danCase-19023To-19019:pinyin=dangCase-19018To-19007:pinyin=daoCase-19006To-19004:pinyin=deCase-19003To-18997:pinyin=dengCase-18996To

9、-18978:pinyin=diCase-18977To-18962:pinyin=dianCase-18961To-18953:pinyin=diaoCase-18952To-18784:pinyin=dieCase-18783To-18775:pinyin=dingCase-18774To-18774:pinyin=diuCase-18773To-18527:pinyin=dongCase-18526To-18519:pinyin=faCase-18518To-18502:pinyin=fanCase-18501To-18491:pinyin=fangCase-18490To-18479:

10、pinyin=feiCase-18478To-18464:pinyin=fenCase-18463To-18449:pinyin=fengCase-18448To-18448:pinyin=foCase-18447To-18447:pinyin=fouCase-18446To-18240:pinyin=fuCase-18239To-18238:pinyin=gaCase-18237To-18232:pinyin=gaiCase-18231To-18221:pinyin=ganCase-18220To-18212:pinyin=gangCase-18211To-18202:pinyin=gaoC

11、ase-18201To-18185:pinyin=geCase-18184To-18184:pinyin=geiCase-18183To-18182:pinyin=genCase-18181To-18013:pinyin=gengCase-18012To-17998:pinyin=gongCase-17997To-17989:pinyin=gouCase-17988To-17971:pinyin=guCase-17970To-17965:pinyin=guaCase-17964To-17962:pinyin=guaiCase-17961To-17951:pinyin=guanCase-1795

12、0To-17948:pinyin=guangCase-17947To-17932:pinyin=guiCase-17931To-17929:pinyin=gunCase-17928To-17923:pinyin=guoCase-17922To-17760:pinyin=haCase-17759To-17753:pinyin=haiCase-17752To-17734:pinyin=hanCase-17733To-17731:pinyin=hangCase-17730To-17722:pinyin=haoCase-17721To-17704:pinyin=heCase-17703To-17702

13、:pinyin=heiCase-17701To-17698:pinyin=henCase-17697To-17693:pinyin=hengCase-17692To-17684:pinyin=hongCase-17683To-17677:pinyin=houCase-17676To-17497:pinyin=huCase-17496To-17488:pinyin=huaCase-17487To-17483:pinyin=huaiCase-17482To-17469:pinyin=huanCase-17468To-17455:pinyin=huangCase-17454To-17434:piny

14、in=huiCase-17433To-17428:pinyin=hunCase-17427To-17418:pinyin=huoCase-17417To-17203:pinyin=jiCase-17202To-17186:pinyin=jiaCase-17185To-16984:pinyin=jianCase-16983To-16971:pinyin=jiangCase-16970To-16943:pinyin=jiaoCase-16942To-16916:pinyin=jieCase-16915To-16734:pinyin=jinCase-16733To-16709:pinyin=jing

15、Case-16708To-16707:pinyin=jiongCase-16706To-16690:pinyin=jiuCase-16689To-16665:pinyin=juCase-16664To-16658:pinyin=juanCase-16657To-16648:pinyin=jueCase-16647To-16475:pinyin=junCase-16474To-16471:pinyin=kaCase-16470To-16466:pinyin=kaiCase-16465To-16460:pinyin=kanCase-16459To-16453:pinyin=kangCase-164

16、52To-16449:pinyin=kaoCase-16448To-16434:pinyin=keCase-16433To-16430:pinyin=kenCase-16429To-16428:pinyin=kengCase-16427To-16424:pinyin=kongCase-16423To-16420:pinyin=kouCase-16419To-16413:pinyin=kuCase-16412To-16408:pinyin=kuaCase-16407To-16404:pinyin=kuaiCase-16403To-16402:pinyin=kuanCase-16401To-163

17、94:pinyin=kuangCase-16393To-16221:pinyin=kuiCase-16220To-16217:pinyin=kunCase-16216To-16213:pinyin=kuoCase-16212To-16206:pinyin=laCase-16205To-16203:pinyin=laiCase-16202To-16188:pinyin=lanCase-16187To-16181:pinyin=langCase-16180To-16172:pinyin=laoCase-16171To-16170:pinyin=leCase-16169To-16159:pinyin

18、=leiCase-16158To-16156:pinyin=lengCase-16155To-15960:pinyin=liCase-15959To-15959:pinyin=liaCase-15958To-15945:pinyin=lianCase-15944To-15934:pinyin=liangCase-15933To-15921:pinyin=liaoCase-15920To-15916:pinyin=lieCase-15915To-15904:pinyin=linCase-15903To-15890:pinyin=lingCase-15889To-15879:pinyin=liuC

19、ase-15878To-15708:pinyin=longCase-15707To-15702:pinyin=louCase-15701To-15682:pinyin=luCase-15681To-15668:pinyin=lvCase-15667To-15662:pinyin=luanCase-15661To-15660:pinyin=lueCase-15659To-15653:pinyin=lunCase-15652To-15641:pinyin=luoCase-15640To-15632:pinyin=maCase-15631To-15626:pinyin=maiCase-15625To

20、-15455:pinyin=manCase-15454To-15449:pinyin=mangCase-15448To-15437:pinyin=maoCase-15436To-15436:pinyin=meCase-15435To-15420:pinyin=meiCase-15419To-15417:pinyin=menCase-15416To-15409:pinyin=mengCase-15408To-15395:pinyin=miCase-15394To-15386:pinyin=mianCase-15385To-15378:pinyin=miaoCase-15377To-15376:p

21、inyin=mieCase-15375To-15370:pinyin=minCase-15369To-15364:pinyin=mingCase-15363To-15363:pinyin=miuCase-15362To-15184:pinyin=moCase-15183To-15181:pinyin=mouCase-15180To-15166:pinyin=muCase-15165To-15159:pinyin=naCase-15158To-15154:pinyin=naiCase-15153To-15151:pinyin=nanCase-15150To-15150:pinyin=nangCa

22、se-15149To-15145:pinyin=naoCase-15144To-15144:pinyin=neCase-15143To-15142:pinyin=neiCase-15141To-15141:pinyin=nenCase-15140To-15140:pinyin=nengCase-15139To-15129:pinyin=niCase-15128To-15122:pinyin=nianCase-15121To-15120:pinyin=niangCase-15119To-15118:pinyin=niaoCase-15117To-15111:pinyin=nieCase-1511

23、0To-15110:pinyin=ninCase-15109To-14942:pinyin=ningCase-14941To-14938:pinyin=niuCase-14937To-14934:pinyin=nongCase-14933To-14931:pinyin=nuCase-14930To-14930:pinyin=nvCase-14929To-14929:pinyin=nuanCase-14928To-14927:pinyin=nueCase-14926To-14923:pinyin=nuoCase-14922To-14922:pinyin=oCase-14921To-14915:p

24、inyin=ouCase-14914To-14909:pinyin=paCase-14908To-14903:pinyin=paiCase-14902To-14895:pinyin=panCase-14894To-14890:pinyin=pangCase-14889To-14883:pinyin=paoCase-14882To-14874:pinyin=peiCase-14873To-14872:pinyin=penCase-14871To-14858:pinyin=pengCase-14857To-14679:pinyin=piCase-14678To-14675:pinyin=pianC

25、ase-14674To-14671:pinyin=piaoCase-14670To-14669:pinyin=pieCase-14668To-14664:pinyin=pinCase-14663To-14655:pinyin=pingCase-14654To-14646:pinyin=poCase-14645To-14631:pinyin=puCase-14630To-14595:pinyin=qiCase-14594To-14430:pinyin=qiaCase-14429To-14408:pinyin=qianCase-14407To-14400:pinyin=qiangCase-1439

26、9To-14385:pinyin=qiaoCase-14384To-14380:pinyin=qieCase-14379To-14369:pinyin=qinCase-14368To-14356:pinyin=qingCase-14355To-14354:pinyin=qiongCase-14353To-14346:pinyin=qiuCase-14345To-14171:pinyin=quCase-14170To-14160:pinyin=quanCase-14159To-14152:pinyin=queCase-14151To-14150:pinyin=qunCase-14149To-14

27、146:pinyin=ranCase-14145To-14141:pinyin=rangCase-14140To-14138:pinyin=raoCase-14137To-14136:pinyin=reCase-14135To-14126:pinyin=renCase-14125To-14124:pinyin=rengCase-14123To-14123:pinyin=riCase-14122To-14113:pinyin=rongCase-14112To-14110:pinyin=rouCase-14109To-14100:pinyin=ruCase-14099To-14098:pinyin

28、=ruanCase-14097To-14095:pinyin=ruiCase-14094To-14093:pinyin=runCase-14092To-14091:pinyin=ruoCase-14090To-14088:pinyin=saCase-14087To-14084:pinyin=saiCase-14083To-13918:pinyin=sanCase-13917To-13915:pinyin=sangCase-13914To-13911:pinyin=saoCase-13910To-13908:pinyin=seCase-13907To-13907:pinyin=senCase-1

29、3906To-13906:pinyin=sengCase-13905To-13897:pinyin=shaCase-13896To-13895:pinyin=shaiCase-13894To-13879:pinyin=shanCase-13878To-13871:pinyin=shangCase-13870To-13860:pinyin=shaoCase-13859To-13848:pinyin=sheCase-13847To-13832:pinyin=shenCase-13831To-13659:pinyin=shengCase-13658To-13612:pinyin=shiCase-13

30、611To-13602:pinyin=shouCase-13601To-13407:pinyin=shuCase-13406To-13405:pinyin=shuaCase-13404To-13401:pinyin=shuaiCase-13400To-13399:pinyin=shuanCase-13398To-13396:pinyin=shuangCase-13395To-13392:pinyin=shuiCase-13391To-13388:pinyin=shunCase-13387To-13384:pinyin=shuoCase-13383To-13368:pinyin=siCase-1

31、3367To-13360:pinyin=songCase-13359To-13357:pinyin=souCase-13356To-13344:pinyin=suCase-13343To-13341:pinyin=suanCase-13340To-13330:pinyin=suiCase-13329To-13327:pinyin=sunCase-13326To-13319:pinyin=suoCase-13318To-13148:pinyin=taCase-13147To-13139:pinyin=taiCase-13138To-13121:pinyin=tanCase-13120To-131

32、08:pinyin=tangCase-13107To-13097:pinyin=taoCase-13096To-13096:pinyin=teCase-13095To-13092:pinyin=tengCase-13091To-13077:pinyin=tiCase-13076To-13069:pinyin=tianCase-13068To-13064:pinyin=tiaoCase-13063To-13061:pinyin=tieCase-13060To-12889:pinyin=tingCase-12888To-12876:pinyin=tongCase-12875To-12872:pin

33、yin=touCase-12871To-12861:pinyin=tuCase-12860To-12859:pinyin=tuanCase-12858To-12853:pinyin=tuiCase-12852To-12850:pinyin=tunCase-12849To-12839:pinyin=tuoCase-12838To-12832:pinyin=waCase-12831To-12830:pinyin=waiCase-12829To-12813:pinyin=wanCase-12812To-12803:pinyin=wangCase-12802To-12608:pinyin=weiCas

34、e-12607To-12598:pinyin=wenCase-12597To-12595:pinyin=wengCase-12594To-12586:pinyin=woCase-12585To-12557:pinyin=wuCase-12556To-12360:pinyin=xiCase-12359To-12347:pinyin=xiaCase-12346To-12321:pinyin=xianCase-12320To-12301:pinyin=xiangCase-12300To-12121:pinyin=xiaoCase-12120To-12100:pinyin=xieCase-12099T

35、o-12090:pinyin=xinCase-12089To-12075:pinyin=xingCase-12074To-12068:pinyin=xiongCase-12067To-12059:pinyin=xiuCase-12058To-12040:pinyin=xuCase-12039To-11868:pinyin=xuanCase-11867To-11862:pinyin=xueCase-11861To-11848:pinyin=xunCase-11847To-11832:pinyin=yaCase-11831To-11799:pinyin=yanCase-11798To-11782:

36、pinyin=yangCase-11781To-11605:pinyin=yaoCase-11604To-11590:pinyin=yeCase-11589To-11537:pinyin=yiCase-11536To-11359:pinyin=yinCase-11358To-11341:pinyin=yingCase-11340To-11340:pinyin=yoCase-11339To-11325:pinyin=yongCase-11324To-11304:pinyin=youCase-11303To-11098:pinyin=yuCase-11097To-11078:pinyin=yuan

37、Case-11077To-11068:pinyin=yueCase-11067To-11056:pinyin=yunCase-11055To-11053:pinyin=zaCase-11052To-11046:pinyin=zaiCase-11045To-11042:pinyin=zanCase-11041To-11039:pinyin=zangCase-11038To-11025:pinyin=zaoCase-11024To-11021:pinyin=zeCase-11020To-11020:pinyin=zeiCase-11019To-11019:pinyin=zenCase-11018T

38、o-11015:pinyin=zengCase-11014To-10839:pinyin=zhaCase-10838To-10833:pinyin=zhaiCase-10832To-10816:pinyin=zhanCase-10815To-10801:pinyin=zhangCase-10800To-10791:pinyin=zhaoCase-10790To-10781:pinyin=zheCase-10780To-10765:pinyin=zhenCase-10764To-10588:pinyin=zhengCase-10587To-10545:pinyin=zhiCase-10544To

39、-10534:pinyin=zhongCase-10533To-10520:pinyin=zhouCase-10519To-10332:pinyin=zhuCase-10331To-10330:pinyin=zhuaCase-10329To-10329:pinyin=zhuaiCase-10328To-10323:pinyin=zhuanCase-10322To-10316:pinyin=zhuangCase-10315To-10310:pinyin=zhuiCase-10309To-10308:pinyin=zhunCase-10307To-10297:pinyin=zhuoCase-102

40、96To-10282:pinyin=ziCase-10281To-10275:pinyin=zongCase-10274To-10271:pinyin=zouCase-10270To-10263:pinyin=zuCase-10262To-10261:pinyin=zuanCase-10260To-10257:pinyin=zuiCase-10256To-10255:pinyin=zunCase-10254To-10254:pinyin=zuoCaseElse:pinyin=pEndSelectEndFunctionFunctiongetpy(str)Fori=1ToLen(str)getpy=getpypinyin(Mid(str,i,1)NextiEndFunction汉字转拼音步骤5：代码输入完成后，直接关闭VisualBasic编辑窗口，返回Excel编辑状态;汉字转拼音步骤6：自定义函数就能够用了，如：选中A2单元格，输入公式：=getpy(A2)。看了excel2020汉字转拼音的方法还看了：1.excel2020汉字转拼音的方法2.excel怎么把把的汉字转换成拼音3.怎么使用excel2007汉字转拼音功能4.excel2020转换的方法5.excel2020打字打不出来的解决方法6.怎样将txt转换excel的方法7.excel2020设置页眉的方法