如何在excel中把汉字转换成拼音

1、WORD 格式整理代码输入完成后，关闭 Visual Basic 编辑窗口，返回6. 自定义函数就可以用了，如：选中D2 单元格，输入公式： =getpy(A2) 。”组合键 ) ，状态；Excel 编辑状Excel 自定义函数方法1. 启动 Excel 2003 ( 其它版本请仿照操作 ) ，打开相应的工作表；2. 执行“工具 T宏T Visual Basic编辑器”命令 (或者直接按“Alt+F11进入 Visual Basic 编辑状态；3. 执行“插入 T 模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑4?将代码输入其中；5.态；专业知识分享有极个别的汉字不能转换，手动

2、就可以了！很方便了Function pinyin(p As String) As String i = Asc(p)Select Case iCase -20319 To -20318:Case -20317 To -20305:Case -20304 To -20296:Case -20295 To -20293:Case -20292 To -20284:Case -20283 To -20266:Case -20265 To -20258:Case -20257 To -20243:Case -20242 To -20231:Case -20230 To -20052:Case -200

3、51 To -20037:Case -20036 To -20033:Case -20032 To -20027:Case -20026 To -20003:Case -20002 To -19991:Case -19990 To -19987:Case -19986 To -19983:Case -19982 To -19977:Case -19976 To -19806:Case -19805 To -19785:Case -19784 To -19776:Case -19775 To -19775:Case -19774 To -19764:Case -19763 To -19757:C

4、ase -19756 To -19752:Case -19751 To -19747:Case -19746 To -19742:Case -19741 To -19740:Case -19739 To -19729:pin yi n p=i n yi n pin yi n pin yi n p=i n yi n p=i n yi n pin yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n pin yi n pin yi n p=i n yi n pin yi n pin yi n p=i n yi n p=i n yi n pin

5、yi n pin yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n pin yi n="a "="ai "="an="ang "="ao="ba " ="bai " ="ban " ="bang "= "bao "="bei "="ben "="beng="bi

6、 "="bia n "="biao "="bie " ="bin " ="bi ng "="bo "="bu "="ca="cai="can="cang="cao "="ceng="cha "Case -19728 To -19726:pin yi n ="chai "Case -19725 To -Case -19715 ToCase

7、-19540 To -19716:19541:Case -19531 To -19532:Case -19525 To -19526:Case -19515 To -19516:Case -19500 To -19501:19485:Case -19484 ToCase -19479 To -19480:19468:Case -19467 ToCase -19289 To -19290:19289:Case -19288 ToCase -19281 To -19282:Case -19275 To -19276:19271:Case -19270 ToCase -19263 To -19264

8、:19262:Case -19261 To19250:Case -19249 ToCase -19243 To -19244:19243:Case -19242 ToCase -19238 To -19239:Case -19235 To -19236:19228:Case -19227 To -19225: Case -19224 To -19225: Case -1199221198: To - Case CCaassee -1199221123 :T o -19039:Case -19038 To19024:Case -19023 ToCase -19018 To -19019:1900

9、7:Case -19006 To19004:Case -19003 ToCase -18996 To -18997:18978:Case -18977 ToCase -18961 To -18962:18953:Case -18952 ToCase -18783 To -18784:Case -18774 To -18775:Case -18773 To -18774:Case -18526 To -18519:Case -18518 ToCase -18501 To -18527:18502:Case -18490 To -18491:Case -18478 To -18479:18464:

10、Case -18463 To18449:pin yi n p=i n yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n p=i n yi n p=i n yi n p=i n yi n pin yi n pin yi n pin yi n pin yi n p=i n yi n p=i n yi n pin yi n pin yi n pin yi n p=i n yi n pin yi n p=i n yi n p=i n yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n pi

11、n yi n p=i n yi n pin yi n pin yi n p=i n yi n pin yi n pin yi n pin yi n pin yi n pin yi n pin yi n p=i n yi n p=i n yi n pin yi n p=i n yi n pin yi n="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; ="da ng "="dao "="de "="de ng "="di "="dia n "="diao "="die "="di ng "="diu " ="do ng "="fa "="fan "="fang "="fei "="fen "="feng

14、"Case -18448 To -Case -18447 To -18448:18447:Case -18446 To18240:Case -18239 ToCase -18237 To -18238:18232:Case -18231 To -18221:-18220 To -Case 18212:Case -18211 ToCase -18201 To -18202:18185:Case -18184 ToCase -18183 To18184:Case -18181 To -Case -1188001123 :T o -18182:Case -17997 To -17998:C

15、ase -17988 To -17989:Case -17970 To -17971:Case -17964 To -17965:Case -17961 To -17962:Case -17950 To -17951:Case -17947 To -17948:Case -17931 To -17932:Case -17928 To -17929:Case -17922 To -17923:Case -17759 To -17760:Case -17752 To -17753:Case -17733 To -17734:Case -17730 To -17731:17722:Case -177

16、21 ToCase -17703 To -17704:17702:Case -17701 ToCase -17697 To -17698:Case -17692 To -17693:Case -17683 To -17684:Case -17676 To -17677:17497:Case -17496 ToCase -17487 To -17488:17483:Case -17482 ToCase -17468 To -17469:Case -17454 To -17455:Case -17433 To -17434:Case -17427 To -17428:17418:Case -174

17、17 ToCase -17202 To -17203:17186:Case -17185 Topin yi n p=i n yi n pin yi n pin yi n p=i n yi n pin yi n pin yi n pin yi n p=i n yi n pin yi n pin yi n pin yi n pin yi n pin yi n p=i n yi n p=i n yi n pin yi n pin yi n p=i n yi n pin yi n pin yi n pin yi n pin yi n p=i n yi n pin yi n p=i n yi n pin

18、 yi n p=i n yi n p=i n yi n pin yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n pin yi n pin yi n p=i n yi n pin yi n p=i n yi n pin yi n pin yi n="fo "="fou "="fU "="ga "="gai "="ga n="ga ng="gao "="

19、;ge "="gei " ="ge n " ="ge ng " ="go ng " ="gou " ="gu " ="gua " ="guai " ="gua n " ="gua ng "= "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 -16983 To -pin yi n ="jia ng "Case -16970 To - 16971:p=i n yi n ="jiao "Case -16942 To -16943:Casep=i n yi n ="jie "16916: -Case -16915 To -pin yi n ="jin "Case -16733 To - 16734:p=i n yi n ="ji ng "16709:=Case -16708 To -pin yi n

22、 ="ji ong "-16707:=Case -16706 To -pin yi n ="jiu "-16690:Case -16689 To -pin yi n ="ju "Case -16664 To - 16665:p=i n yi n ="jua n "16658:Case -16657 To - 16658:pin yi n ="jue "16648:=Case -16647 To - 16648:pin yi n ="jun "16475:Case -16474

23、 To - 16475:p=i n yi n ="ka "16471:Case -16470 To - 16471:p=i n yi n ="kai "16466:Case -16465 To -p=i n yi n ="kan "-16460:=Case -16459 To -16453:p=i n yi n ="kang "Case -16452 To -pin yi n ="kao "-16449:Case -16448 To -pin yi n ="ke "-1643

24、4:p=i n yi n ="ken "Case -16433 To -16430:Case -16429 To - 16430:p=i n yi n ="keng "16428:Case -16427 To -pin yi n ="kong "16424:=Case -16423 To - 16424:pin yi n ="kou "16420:-16419 To -16420: Casep=i n yi n ="ku "16413: -p=i n yi n ="kua "

25、Case -16412 To -16408:Case -16407 To - 16408:p=i n yi n ="kuai "16404:Case -16403 To - 16404:p=i n yi n ="kuan "16402:Case -16401 To - 16402:p=i n yi n ="kuang16394:Case -16393 To -pin yi n ="kui "-16220 To -16221:Casep=i n yi n ="kun "Case -162167 :T o -

26、p=i n yi n ="kuo "16213:=Case -16212 To -pin yi n ="la "16206:Case -16205 To -p=i n yi n ="lai "16203:=Case -16202 To -pin yi n ="Ian "16188:=Case -16187 To -pin yi n ="la ng "16181:=Case -16180 To - 16181:pin yi n ="lao "-16172:=Case -1617

27、1 To -pin yi n ="le "Case -16169 To - 16170:p=i n yi n ="lei "-16159:=Case -16158 To -pin yi n="le ng "16156:Case -16155 To -p=i n yi n ="li "-15960:=Case -15959 To -15959:pin yi n ="lia "Case -15958 To - 15959:p=i n yi n ="lian "-15945:=Ca

28、se -15944 To -pin yi n="lia ng "15934:Case -15933 To -pin yi n ="liao "15921:Case -15920 To - 15921:p=i n yi n ="lie "15916:=Case -15915 To -pin yi n ="lin "15904:Case -15903 To -15890:Case -15889 To -pin yip=i n yi="ling "="liu "15879:Case

29、 -15878 ToCase -15707 To -15708:15702:pin yipin yi="long "="lou "Case -15701 ToCase -15681 To -15682:15668:Case -15667 To15662:pin yipin yipin yi="lu ":"lv "="luan "Case -15661 ToCase -15659 To -15660:15653:pin yipin yi="lue="lunCase -15652

30、 ToCase -15640 To -15641:Case -15631 To -15632:Case -15625 To -15626:Case -15454 To -15455:Case -15448 To -15449:Case -15436 To -15437:15436:Case -15435 To15420:pin yipin yipin yipin yipin yipin yipin yipin yi="luo="ma "="mai "="ma n "="ma ng"= "mao

31、"="me "="mei "Case -15419 ToCase -15416 To -15417:pin yipin yiCase -15408 To -15409:pin yi="me n "="me ng"= "mi "Case -15394 To -15395:pin yi="mia n "Case -15385 To -15386:pin yi="miao "Case -15377 To -15378:pin yi="mie

32、"Case -15375 To -15376:pin yi="min "Case -15369 To -15370:pin yi="mi ng "Case -15363 To -15364:pin yi="miu "15363:Case -15362 Topin yi15184:="mo "Case -15183 ToCase -15180 To -15181:15166:pin yipin yi="mou "="mu "Case -15165 ToCase -15

33、158 To -15159:Case -15153 To -15154:Case -15150 To -15151:Case -15149 To -15150:15145:pin yipin yipin yipin yipin yiCase -15144 ToCase -15143 To -15144:15142:Case -15141 To15141:Case -15140 To -15140:Case -15139 To -Case -15128 To -15129:Case -15121 To -15122:pin yipin yipin yipin yipin yipin yipin

34、yi="na " ="n ai "="nan "="nang "="nao "="ne " ="n ei "="nen "="neng "="ni "="n ia n "="niang "Case -15119 To -Case -151178 :T o -15111:15120:pin yipin yi="n iao "="n

35、ie "Case-15110 To -15110:pin yi n ="nin "Case -15109 To -14942:pin yi n="ning "Case -14941 To -14938:p=i n yi n="niu ”Case -14937 To -14934:p=i n yi n="nong "Case -14933 To -14931:pin yi n="nu "Case -14930 To -14930:p=i n yi n="nv "Case -14

36、929 To -14929:p=i n yi n="nuan ”Case -14928 To -14927:pin yi n="nue "Case -14926 To -14923:pin yi n="nuo "Case -14922 To -14922:p=i n yi n="o "Case -14921 To -14915:pin yi n="ou "Case -14914 To -14909:pin yi n="pa "Case -14908 To -14903:p=i n yi

37、 n="pai "Case -14902 To -14895:pin yi n="pan "Case -14894 To -14890:pin yi n="pang "Case -14889 To -14883:pin yi n="pao "Case -14882 To -14874:p=i n yi n="pei "Case -14873 To -14872:pin yi n="pen "Case -14871 To -14858:pin yi n="peng &

38、quot;Case -14857 To -14679:p=i n yi n="pi "Case -14678 To -14675:p=i n yi n="pia n "Case -14674 To -14671:pin yi n="piao "Case -14670 To -14669:pin yi n="pie "Case -14668 To -14664:p=i n yi n="p in "Case -14663 To -14655:pin yi n="pi ng "Ca

39、se -14654 To -14646:p=i n yi n="po "Case -14645 To -14631:p=i n yi n="pu "Case -14630 To -14595:pin yi n="qi "Case -14594 To -14430:pin yi n="qia "Case -14429 To -14408:pin yi n="qia n "Case -14407 To -14400:pin yi n="qia ngCase -14399 To -14385

40、:pin yi n="qiao "Case -14384 To -14380:pin yi n="qie "Case -14379 To -14369:p=i n yi n="qin "Case -14368 To -14356:pin yi n="qi ng "Case -14355 To -14354:pin yi n="qio ngCase -14353 To -14346:p=i n yi n"= "qiu "Case -14345 To -14171:p=i n y

41、i n="qu "Case -14170 To -14160:pin yi n="qua nCase -14159 To -14152:pin yi n="que "Case -14151 To -14150:pin yi n="qun "Case -14149 To -14146:pin yi n="ran "Case -14145 To -14141:p=i n yi n="ra ng "Case -14140 To -14138:pin yi n="rao "

42、Case -14137 To -14136: pin yi n ="re "CaseCase-14135 To -14126:-14125 To -14124:pin yi n p=i n yi n="ren " ="reng "Case-14123 To -14123:pin yi n-H-iiCase-14122 To -14113:p=i n yi n="rong "Case -14112 To -14110:p=i n yi n="rou "Case -14109 To -14100:p

43、=i n yi n="ru "Case -14099 To -14098:pin yi n="rua n ”Case -14097 To -14095:pin yi n="rui "Case -14094 To -14093:p=i n yi n="run "Case -14092 To -14091:pin yi n="ruo "Case -14090 To -14088:pin yi n="sa "Case -14087 To -14084:p=i n yi n="sai

44、 "Case -14083 To -13918:pin yi n="sa n "Case -13917 To -13915:pin yi n="sa ng "Case-13914 To -13911:pin yi n="sao "Case -13910 To -13908:p=i n yi n="se "Case-13907 To -13907:pin yi n="se n "Case-13906 To -13906:pin yi n="seng "Case-139

45、05 To -13897:pin yi n="sha "Case-13896 To -13895:p=i n yi n="shai "Case-13894 To -13879:pin yi n="sha n "Case-13878 To -13871:p=i n yi n="shang "Case-13870 To -13860:pin yi n="shao "Case-13859 To -13848:p=i n yi n="she "Case-13847 To -13832

46、:pin yi n="she n "Case-13831 To -13659:p=i n yi n="sheng "Case-13658 To -13612:pin yi n="shi "Case -13611 To -13602:p=i n yi n="shou "Case-13601 To -13407:p=i n yi n="shu "Case-13406 To -13405:p=i n yi n="shua "Case-13404 To -13401:pin yi n

47、="shuai "Case-13400 To -13399:p=i n yi n="shua nCase-13398 To -13396:p=i n yi n="shuangCase-13395 To -13392:pin yi n="shui "Case-13391 To -13388:p=i n yi n="sh un "Case-13387 To -13384:p=i n yi n="shuo "Case-13383 To -13368:pin yi n="si "Ca

48、se-13367 To -13360:pin yi n="song "Case-13359 To -13357:pin yi n="sou "Case-13356 To -13344:p=i n yi n="su "Case-13343 To -13341:p=i n yi n="sua n "Case-13340 To -13330:p=i n yi n="sui "Case-13329 To -13327:pin yi n="sun "Case -13326 To -13

49、319:pin yi n="suoCase -13318 To -pin yi n ="ta "Case -13147 To - 13148:p=i n yi n ="tai "-13139:p=i n yi n ="tan "Case -13138 To -13121:p=i n yi n ="tang "Case -13120 To -Case -13107 To - 13108:p=i n yi n ="tao "13097:Case -13096 To - 13097:p=i

50、n yi n ="te "-13096:Case -13095 To -13092:pin yi n= ="te ng "Case -13091 To -p=i n yi n ="ti "Case -13076 To - 13077:p=i n yi n ="tian ”-13069:Case -13068 To -pin yi n ="tiao "13064:Case -13063 To -pin yi n ="tie "-13061:=Case -13060 To -12889:p

51、in yi n= ="ti ng "Case -12888 To - 12889:pin yi n ="tong "Case -12875 To - 12876:p=i n yi n ="tou "12872:=Case -12871 To -pin yi n ="tu "12861:Case -12860 To -pin yi n ="tuan "-12859:Case -12858 To -pin yi n ="tui "-12853:p=i n yi n ="

52、tun "Case -12852 To -12850:Case -12849 To - 12850:p=i n yi n ="tuo "-12839:=Case -12838 To -12832:pin yi n= ="wa "Case -12831 To - 12832:pin yi n ="wai "Case -12829 To - 12830:p=i n yi n ="wa n "12813:=Case -12812 To -pin yi n ="wang "12803:=Cas

53、e -12802 To -pin yi n ="wei "Case -12607 To - 12608:p=i n yi n ="we n "Case -12597 To - 12598:p=i n yi n ="weng "12595:=Case -12594 To -pin yi n ="wo "-12586:=Case -12585 To -12557:pin yi n="wu "Case -12556 To - 12557:p=i n yi n ="xi "-1236

54、0:=Case -12359 To -p=i n yi n ="xia "Case -12346 To -pin yi n ="xia n "12321:Case -12320 To - 12321:p=i n yi n ="xia ng12301:Case -12300 To - 12301:p=i n yi n "= "xiao "Case -121201 :T o -12100:p=i n yi n ="xie "Case -12099 To -12090:pin yi n="x

55、in "Case -12089 To - 12090:p=i n yi n ="xi ng "12075:Case -12074 To -pin yi n ="xio ng12068:Case -12067 To - 12068:pin yi n ="xiu "-12059:=Case -12058 To -pin yi n ="xu "12040:Case -12039 To -pin yi n ="xua n "11868:=Case -11867 To -pin yi n ="x

56、ue "Case -11861 To - 11862:p=i n yi n ="xun "11848:=Case -11847 To -pin yi n ="ya "11832:=Case -11831 To-pin yi n ="yan "11799: =Case -11798 To -11782:Case -11781 To -Case -11604 To -11605:11590:Case -11589 To11537:Case -11536 ToCase -11358 To -11359:11341:Case -11

57、340 ToCase -11339 To -11340:Case -11324 To -11325:11304:Case -11303 ToCase -11097 To -11098:Case -11077 To11078:Case -11067 To -11068:Case -11055 To -11056:Case -11052 To -11053:Case -11045 To -11046:11042:Case -11041 ToCase -11038 To -11039:Case -11024 To11025:Case -11020 To11021:11020:Case -11019 To -11019:Case -11018 To -11015:Case -11014 To -Case -10838 To -10839:10833:Case -10832 ToCase -10815 To10816:Case -10800 To -10801:10791:Case -10790 ToCase -10780 To -10781:10765:Case -10764 ToCase -10587 To -10588:10545:Case -10544