Excel单元格文字转换成拼音方法

1.Æô¶¯Excel2003£¨ÆäËü°æ±¾Çë·ÂÕÕ²Ù×÷£©£¬´ò¿ªÏàÓ¦µÄ¹¤×÷±í£»2.Ö´ÐС°¹¤¾ß¡úºê¡úVisualBasic±à¼­Æ÷¡±ÃüÁ»òÕßÖ±½Ó°´¡°Alt+F11¡±×éºÏ¼ü£©£¬½øÈëVisualBasic±à¼­×´Ì¬£»3.Ö´ÐС°²åÈë¡úÄ£¿é¡±ÃüÁ²åÈëÒ»¸öÐÂÄ£¿é¡£ÔÙË«»÷²åÈëµÄÄ£¿é£¬½øÈëÄ£¿é´úÂë±à¼­×´Ì¬£»4.½«´úÂëÊäÈëÆäÖУ»Functionpinyin(pAsString)AsStringi=Asc(p)SelectCaseiCase-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-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:pinyin=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=chanCase-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=chuaiCase-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=cuanCase-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-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: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=gaoCase-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-17950To-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: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:pinyin=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=jingCase-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-16452To-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-16394: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=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