2、就可以了！很方便了Functionpinyin(pAsString)AsStringi=Asc(p)SelectCaseiCase-20319To-20318:Case-20317To-20305:Case-20304To-20296:Case-20295To-20293:Case-20292To-20284:Case-20283To-20266:Case-20265To-20258:Case-20257To-20243:Case-20242To-20231:Case-20230To-20052:Case-200
3、51To-20037:Case-20036To-20033:Case-20032To-20027:Case-20026To-20003:Case-20002To-19991:Case-19990To-19987:Case-19986To-19983:Case-19982To-19977:Case-19976To-19806:Case-19805To-19785:Case-19784To-19776:Case-19775To-19775:Case-19774To-19764:Case-19763To-19757:C
4、ase-19756To-19752:Case-19751To-19747:Case-19746To-19742:Case-19741To-19740:Case-19739To-19729:pinyinp=inyinpinyinpinyinp=inyinp=inyinpinyinpinyinp=inyinpinyinp=inyinpinyinpinyinpinyinp=inyinpinyinpinyinp=inyinp=inyinpin
5、yinpinyinpinyinp=inyinpinyinp=inyinpinyinp=inyinpinyinpinyin="a"="ai"="an="ang"="ao="ba"="bai"="ban"="bang"="bao"="bei"="ben"="beng="bi
6、"="bian"="biao"="bie"="bin"="bing"="bo"="bu"="ca="cai="can="cang="cao"="ceng="cha"Case-19728To-19726:pinyin="chai"Case-19725To-Case-19715ToCase
7、-19540To-19716:19541:Case-19531To-19532:Case-19525To-19526:Case-19515To-19516:Case-19500To-19501:19485:Case-19484ToCase-19479To-19480:19468:Case-19467ToCase-19289To-19290:19289:Case-19288ToCase-19281To-19282:Case-19275To-19276:19271:Case-19270ToCase-19263To-19264
8、:19262:Case-19261To19250:Case-19249ToCase-19243To-19244:19243:Case-19242ToCase-19238To-19239:Case-19235To-19236:19228:Case-19227To-19225:Case-19224To-19225:Case-1199221198:To-CaseCCaassee-1199221123:To-19039:Case-19038To19024:Case-19023ToCase-19018To-19019:1900
9、7:Case-19006To19004:Case-19003ToCase-18996To-18997:18978:Case-18977ToCase-18961To-18962:18953:Case-18952ToCase-18783To-18784:Case-18774To-18775:Case-18773To-18774:Case-18526To-18519:Case-18518ToCase-18501To-18527:18502:Case-18490To-18491:Case-18478To-18479:18464:
10、Case-18463To18449:pinyinp=inyinpinyinp=inyinpinyinp=inyinpinyinp=inyinp=inyinp=inyinpinyinpinyinpinyinpinyinp=inyinp=inyinpinyinpinyinpinyinp=inyinpinyinp=inyinp=inyinpinyinp=inyinpinyinp=inyinpinyinpi
11、nyinp=inyinpinyinpinyinp=inyinpinyinpinyinpinyinpinyinpinyinpinyinp=inyinp=inyinpinyinp=inyinpinyin="chan”="chang"="chao"="che"="chen”="cheng"="chi"="chong"="chou&q
12、uot;="chu"="chuai"="chuan"="chuang"="chui"="chun"="chuo"="ci"="cong"="cou"="cu"="cuan="cui"="cun="cuo"="da"="dai"="dan&
13、quot;="dang"="dao"="de"="deng"="di"="dian"="diao"="die"="ding"="diu"="dong"="fa"="fan"="fang"="fei"="fen"="feng
14、"Case-18448To-Case-18447To-18448:18447:Case-18446To18240:Case-18239ToCase-18237To-18238:18232:Case-18231To-18221:-18220To-Case18212:Case-18211ToCase-18201To-18202:18185:Case-18184ToCase-18183To18184:Case-18181To-Case-1188001123:To-18182:Case-17997To-17998:C
15、ase-17988To-17989:Case-17970To-17971:Case-17964To-17965:Case-17961To-17962:Case-17950To-17951:Case-17947To-17948:Case-17931To-17932:Case-17928To-17929:Case-17922To-17923:Case-17759To-17760:Case-17752To-17753:Case-17733To-17734:Case-17730To-17731:17722:Case-177
16、21ToCase-17703To-17704:17702:Case-17701ToCase-17697To-17698:Case-17692To-17693:Case-17683To-17684:Case-17676To-17677:17497:Case-17496ToCase-17487To-17488:17483:Case-17482ToCase-17468To-17469:Case-17454To-17455:Case-17433To-17434:Case-17427To-17428:17418:Case-174
17、17ToCase-17202To-17203:17186:Case-17185Topinyinp=inyinpinyinpinyinp=inyinpinyinpinyinpinyinp=inyinpinyinpinyinpinyinpinyinpinyinp=inyinp=inyinpinyinpinyinp=inyinpinyinpinyinpinyinpinyinp=inyinpinyinp=inyinpin
18、yinp=inyinp=inyinpinyinpinyinp=inyinpinyinp=inyinpinyinp=inyinpinyinpinyinpinyinp=inyinpinyinp=inyinpinyinpinyin="fo"="fou"="fU"="ga"="gai"="gan="gang="gao"="
19、;ge"="gei"="gen"="geng"="gong"="gou"="gu"="gua"="guai"="guan"="guang"="gui"="gun"="guo"="ha"="hai"="han
20、"="hang"="hao"="he"="hei"="hen"="heng"="hong"="hou"="hu"="hua"="huai"="huan"="huang"="hui"="hun"="huo"="ji=&q
21、uot;jia16984:=Case-16983To-pinyin="jiang"Case-16970To-16971:p=inyin="jiao"Case-16942To-16943:Casep=inyin="jie"16916:-Case-16915To-pinyin="jin"Case-16733To-16734:p=inyin="jing"16709:=Case-16708To-pinyin
22、="jiong"-16707:=Case-16706To-pinyin="jiu"-16690:Case-16689To-pinyin="ju"Case-16664To-16665:p=inyin="juan"16658:Case-16657To-16658:pinyin="jue"16648:=Case-16647To-16648:pinyin="jun"16475:Case-16474
23、To-16475:p=inyin="ka"16471:Case-16470To-16471:p=inyin="kai"16466:Case-16465To-p=inyin="kan"-16460:=Case-16459To-16453:p=inyin="kang"Case-16452To-pinyin="kao"-16449:Case-16448To-pinyin="ke"-1643
24、4:p=inyin="ken"Case-16433To-16430:Case-16429To-16430:p=inyin="keng"16428:Case-16427To-pinyin="kong"16424:=Case-16423To-16424:pinyin="kou"16420:-16419To-16420:Casep=inyin="ku"16413:-p=inyin="kua"
25、Case-16412To-16408:Case-16407To-16408:p=inyin="kuai"16404:Case-16403To-16404:p=inyin="kuan"16402:Case-16401To-16402:p=inyin="kuang16394:Case-16393To-pinyin="kui"-16220To-16221:Casep=inyin="kun"Case-162167:To-
26、p=inyin="kuo"16213:=Case-16212To-pinyin="la"16206:Case-16205To-p=inyin="lai"16203:=Case-16202To-pinyin="Ian"16188:=Case-16187To-pinyin="lang"16181:=Case-16180To-16181:pinyin="lao"-16172:=Case-1617
27、1To-pinyin="le"Case-16169To-16170:p=inyin="lei"-16159:=Case-16158To-pinyin="leng"16156:Case-16155To-p=inyin="li"-15960:=Case-15959To-15959:pinyin="lia"Case-15958To-15959:p=inyin="lian"-15945:=Ca
28、se-15944To-pinyin="liang"15934:Case-15933To-pinyin="liao"15921:Case-15920To-15921:p=inyin="lie"15916:=Case-15915To-pinyin="lin"15904:Case-15903To-15890:Case-15889To-pinyip=inyi="ling"="liu"15879:Case
29、-15878ToCase-15707To-15708:15702:pinyipinyi="long"="lou"Case-15701ToCase-15681To-15682:15668:Case-15667To15662:pinyipinyipinyi="lu":"lv"="luan"Case-15661ToCase-15659To-15660:15653:pinyipinyi="lue="lunCase-15652
30、ToCase-15640To-15641:Case-15631To-15632:Case-15625To-15626:Case-15454To-15455:Case-15448To-15449:Case-15436To-15437:15436:Case-15435To15420:pinyipinyipinyipinyipinyipinyipinyipinyi="luo="ma"="mai"="man"="mang"="mao
31、"="me"="mei"Case-15419ToCase-15416To-15417:pinyipinyiCase-15408To-15409:pinyi="men"="meng"="mi"Case-15394To-15395:pinyi="mian"Case-15385To-15386:pinyi="miao"Case-15377To-15378:pinyi="mie
32、"Case-15375To-15376:pinyi="min"Case-15369To-15370:pinyi="ming"Case-15363To-15364:pinyi="miu"15363:Case-15362Topinyi15184:="mo"Case-15183ToCase-15180To-15181:15166:pinyipinyi="mou"="mu"Case-15165ToCase-15
33、158To-15159:Case-15153To-15154:Case-15150To-15151:Case-15149To-15150:15145:pinyipinyipinyipinyipinyiCase-15144ToCase-15143To-15144:15142:Case-15141To15141:Case-15140To-15140:Case-15139To-Case-15128To-15129:Case-15121To-15122:pinyipinyipinyipinyipinyipinyipin
34、yi="na"="nai"="nan"="nang"="nao"="ne"="nei"="nen"="neng"="ni"="nian"="niang"Case-15119To-Case-151178:To-15111:15120:pinyipinyi="niao"="n
35、ie"Case-15110To-15110:pinyin="nin"Case-15109To-14942:pinyin="ning"Case-14941To-14938:p=inyin="niu”Case-14937To-14934:p=inyin="nong"Case-14933To-14931:pinyin="nu"Case-14930To-14930:p=inyin="nv"Case-14
36、929To-14929:p=inyin="nuan”Case-14928To-14927:pinyin="nue"Case-14926To-14923:pinyin="nuo"Case-14922To-14922:p=inyin="o"Case-14921To-14915:pinyin="ou"Case-14914To-14909:pinyin="pa"Case-14908To-14903:p=inyi
37、n="pai"Case-14902To-14895:pinyin="pan"Case-14894To-14890:pinyin="pang"Case-14889To-14883:pinyin="pao"Case-14882To-14874:p=inyin="pei"Case-14873To-14872:pinyin="pen"Case-14871To-14858:pinyin="peng&
38、quot;Case-14857To-14679:p=inyin="pi"Case-14678To-14675:p=inyin="pian"Case-14674To-14671:pinyin="piao"Case-14670To-14669:pinyin="pie"Case-14668To-14664:p=inyin="pin"Case-14663To-14655:pinyin="ping"Ca
39、se-14654To-14646:p=inyin="po"Case-14645To-14631:p=inyin="pu"Case-14630To-14595:pinyin="qi"Case-14594To-14430:pinyin="qia"Case-14429To-14408:pinyin="qian"Case-14407To-14400:pinyin="qiangCase-14399To-14385
40、:pinyin="qiao"Case-14384To-14380:pinyin="qie"Case-14379To-14369:p=inyin="qin"Case-14368To-14356:pinyin="qing"Case-14355To-14354:pinyin="qiongCase-14353To-14346:p=inyin"="qiu"Case-14345To-14171:p=iny
41、in="qu"Case-14170To-14160:pinyin="quanCase-14159To-14152:pinyin="que"Case-14151To-14150:pinyin="qun"Case-14149To-14146:pinyin="ran"Case-14145To-14141:p=inyin="rang"Case-14140To-14138:pinyin="rao"
42、Case-14137To-14136:pinyin="re"CaseCase-14135To-14126:-14125To-14124:pinyinp=inyin="ren"="reng"Case-14123To-14123:pinyin-H-iiCase-14122To-14113:p=inyin="rong"Case-14112To-14110:p=inyin="rou"Case-14109To-14100:p
43、=inyin="ru"Case-14099To-14098:pinyin="ruan”Case-14097To-14095:pinyin="rui"Case-14094To-14093:p=inyin="run"Case-14092To-14091:pinyin="ruo"Case-14090To-14088:pinyin="sa"Case-14087To-14084:p=inyin="sai
44、"Case-14083To-13918:pinyin="san"Case-13917To-13915:pinyin="sang"Case-13914To-13911:pinyin="sao"Case-13910To-13908:p=inyin="se"Case-13907To-13907:pinyin="sen"Case-13906To-13906:pinyin="seng"Case-139
45、05To-13897:pinyin="sha"Case-13896To-13895:p=inyin="shai"Case-13894To-13879:pinyin="shan"Case-13878To-13871:p=inyin="shang"Case-13870To-13860:pinyin="shao"Case-13859To-13848:p=inyin="she"Case-13847To-13832
46、:pinyin="shen"Case-13831To-13659:p=inyin="sheng"Case-13658To-13612:pinyin="shi"Case-13611To-13602:p=inyin="shou"Case-13601To-13407:p=inyin="shu"Case-13406To-13405:p=inyin="shua"Case-13404To-13401:pinyin
47、="shuai"Case-13400To-13399:p=inyin="shuanCase-13398To-13396:p=inyin="shuangCase-13395To-13392:pinyin="shui"Case-13391To-13388:p=inyin="shun"Case-13387To-13384:p=inyin="shuo"Case-13383To-13368:pinyin="si"Ca
48、se-13367To-13360:pinyin="song"Case-13359To-13357:pinyin="sou"Case-13356To-13344:p=inyin="su"Case-13343To-13341:p=inyin="suan"Case-13340To-13330:p=inyin="sui"Case-13329To-13327:pinyin="sun"Case-13326To-13
49、319:pinyin="suoCase-13318To-pinyin="ta"Case-13147To-13148:p=inyin="tai"-13139:p=inyin="tan"Case-13138To-13121:p=inyin="tang"Case-13120To-Case-13107To-13108:p=inyin="tao"13097:Case-13096To-13097:p=i
50、nyin="te"-13096:Case-13095To-13092:pinyin=="teng"Case-13091To-p=inyin="ti"Case-13076To-13077:p=inyin="tian”-13069:Case-13068To-pinyin="tiao"13064:Case-13063To-pinyin="tie"-13061:=Case-13060To-12889:p
51、inyin=="ting"Case-12888To-12889:pinyin="tong"Case-12875To-12876:p=inyin="tou"12872:=Case-12871To-pinyin="tu"12861:Case-12860To-pinyin="tuan"-12859:Case-12858To-pinyin="tui"-12853:p=inyin="
52、tun"Case-12852To-12850:Case-12849To-12850:p=inyin="tuo"-12839:=Case-12838To-12832:pinyin=="wa"Case-12831To-12832:pinyin="wai"Case-12829To-12830:p=inyin="wan"12813:=Case-12812To-pinyin="wang"12803:=Cas
53、e-12802To-pinyin="wei"Case-12607To-12608:p=inyin="wen"Case-12597To-12598:p=inyin="weng"12595:=Case-12594To-pinyin="wo"-12586:=Case-12585To-12557:pinyin="wu"Case-12556To-12557:p=inyin="xi"-1236
54、0:=Case-12359To-p=inyin="xia"Case-12346To-pinyin="xian"12321:Case-12320To-12321:p=inyin="xiang12301:Case-12300To-12301:p=inyin"="xiao"Case-121201:To-12100:p=inyin="xie"Case-12099To-12090:pinyin="x
55、in"Case-12089To-12090:p=inyin="xing"12075:Case-12074To-pinyin="xiong12068:Case-12067To-12068:pinyin="xiu"-12059:=Case-12058To-pinyin="xu"12040:Case-12039To-pinyin="xuan"11868:=Case-11867To-pinyin="x
56、ue"Case-11861To-11862:p=inyin="xun"11848:=Case-11847To-pinyin="ya"11832:=Case-11831To-pinyin="yan"11799:=Case-11798To-11782:Case-11781To-Case-11604To-11605:11590:Case-11589To11537:Case-11536ToCase-11358To-11359:11341:Case-11
57、340ToCase-11339To-11340:Case-11324To-11325:11304:Case-11303ToCase-11097To-11098:Case-11077To11078:Case-11067To-11068:Case-11055To-11056:Case-11052To-11053:Case-11045To-11046:11042:Case-11041ToCase-11038To-11039:Case-11024To11025:Case-11020To11021:11020:Case-11019To-11019:Case-11018To-11015:Case-11014To-Case-10838To-10839:10833:Case-10832ToCase-10815To10816:Case-10800To-10801:10791:Case-10790ToCase-10780To-10781:10765:Case-10764ToCase-10587To-10588:10545:Case-10544