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

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

2、便了。Function pinyin(p As String) As Stringi = Asc(p)Select Case iCase -20319 To -20318:pin yi n =a Case -20317 To -20305:pin yi n =ai Case -20304 To -20296:pin yi n =an ”Case -20295 To -20293:pin yi n =ang Case -20292 To -20284:pin yi n =ao Case -20283 To -20266:pin yi n =ba Case -20265 To -20258:pin

3、 yi n =bai Case -20257 To -20243:pin yi n =ban Case -20242 To -20231:pin yi n =bang Case -20230 To -20052:pin yi n =bao Case -20051 To -20037:pin yi n =bei Case -20036 To -20033:pin yi n =ben Case -20032 To -20027:pin yi n =beng Case -20026 To -20003:pin yi n =bi Case -20002 To -19991:pin yi n =bia

4、n Case -19990 To -19987:pin yi n =biao Case -19986 To -19983:pin yi n =bie Case -19982 To -19977:pin yi n =bin Case -19976 To -19806:pin yi n =bi ng Case -19805 To -19785:pin yi n =bo Case -19784 To -19776:pin yi n =bu Case -19775 To -19775:pin yi n =ca Case -19774 To -19764:pin yi n =cai Case -1976

5、3 To -19757:pin yi n =can Case -19756 To -19752:pin yi n =cang Case -19751 To -19747:pin yi n =cao Case -19746 To -19742:pin yi n =ce Case -19741 To -19740:pin yi n =ceng Case -19739 To -19729:pin yi n =cha Case -19728 To -19726:pin yi n =chai Case-19725 To-19716:pin yi n =chan ”Case-19715 To-19541:

6、pin yi n =chang Case-19540 To-19532:pin yi n =chao Case-19531 To-19526:pin yi n =che Case-19525 To-19516:pin yi n =chen ”Case-19515 To-19501:pin yi n =cheng Case-19500 To-19485:pin yi n =chi Case-19484 To-19480:pin yi n =chong Case-19479 To-19468:pin yi n =chou Case-19467 To-19290:pin yi n =chu Case

7、-19289 To-19289:pin yi n =chuai Case-19288 To-19282:pin yi n =chuan Case-19281 To-19276:pin yi n =chuang Case-19275 To-19271:pin yi n =chui Case-19270 To-19264:pin yi n =chun Case-19263 To-19262:pin yi n =chuo Case-19261 To-19250:pin yi n =ci Case-19249 To-19244:pin yi n =cong Case-19243 To-19243:pi

8、n yi n =cou Case-19242 To-19239:pin yi n =cu Case-19238 To-19236:pin yi n =cuan Case-19235 To-19228:pin yi n =cui Case-19227 To-19225:pin yi n =cun Case-19224 To -19219:pin yi n =cuo Case-19218 To -19213:pin yi n =da Case-19212 To-19039:pin yi n =dai Case-19038 To-19024:pin yi n =dan Case-19023 To-1

9、9019:pin yi n =da ng Case-19018 To-19007:pin yi n =dao Case-19006 To-19004:pin yi n =de Case-19003 To-18997:pin yi n =de ng Case-18996 To-18978:pin yi n =di Case-18977 To-18962:pin yi n =dia n Case-18961 To-18953:pin yi n =diao Case-18952 To-18784:pin yi n =die Case-18783 To-18775:pin yi n =di ng Ca

10、se-18774 To-18774:pin yi n =diu Case-18773 To-18527:pin yi n =do ng Case-18526 To -18519:pin yi n =fa Case-18518 To-18502:pin yi n =fan Case-18501 To-18491:pin yi n =fang Case-18490 To-18479:pin yi n =fei Case-18478 To-18464:pin yi n =fen Case-18463 To-18449:pin yi n =feng Case-18448 To-18448:pin yi

11、 n =fo Case-18447 To-18447:pin yi n =fou Case-18446 To-18240:pin yi n =fU Case-18239 To-18238:pin yi n =ga Case-18237 To-18232:pin yi n =gai Case-18231 To-18221:pin yi n =ga n Case-18220 To -18212:pin yi n =ga ng Case -18211 To-18202:pin yi n =gao Case-18201 To-18185:pin yi n =ge Case-18184 To-18184

12、:pin yi n =gei Case-18183 To-18182:pin yi n =ge n Case-18181 To -18013:pin yi n =ge ng Case -18012 To-17998:pin yi n =go ng Case-17997 To-17989:pin yi n =gou Case-17988 To-17971:pin yi n =gu Case-17970 To-17965:pin yi n =gua Case-17964 To-17962:pin yi n =guai Case-17961 To-17951:pin yi n =gua n Case

13、-17950 To-17948:pin yi n =gua ng Case-17947 To-17932:pin yi n =gui Case-17931 To-17929:pin yi n =gun Case-17928 To-17923:pin yi n =guo Case-17922 To-17760:pin yi n =ha Case-17759 To-17753:pin yi n =hai Case-17752 To-17734:pin yi n =han Case-17733 To-17731:pin yi n =hang Case-17730 To-17722:pin yi n

14、=hao Case-17721 To-17704:pin yi n =he Case-17703 To-17702:pin yi n =hei Case-17701 To-17698:pin yi n =hen Case-17697 To-17693:pin yi n =heng Case-17692 To-17684:pin yi n =hong Case-17683 To-17677:pin yi n =hou Case-17676 To-17497:pin yi n =hu Case-17496 To-17488:pin yi n =hua Case-17487 To-17483:pin

15、 yi n =huai Case-17482 To-17469:pin yi n =huan Case-17468 To-17455:pin yi n =huang Case-17454 To-17434:pin yi n =hui Case-17433 To-17428:pin yi n =hun Case-17427 To-17418:pin yi n =huo Case-17417 To-17203:pin yi n =ji Case-17202 To-17186:pin yi n =jia Case-17185 To-16984:pin yi n =jia n Case-16983 T

16、o-16971:pin yi n =jia ng Case-16970 To-16943:pin yi n =jiao Case-16942 To -16916:pin yi n =jie Case-16915 To-16734:pin yi n =jin Case-16733 To-16709:pin yi n =ji ng Case-16708 To-16707:pin yi n =ji ong Case-16706 To-16690:pin yi n =jiu Case-16689 To-16665:pin yi n =ju Case-16664 To-16658:pin yi n =j

17、ua n Case-16657 To-16648:pin yi n =jue Case-16647 To-16475:pin yi n =jun Case-16474 To-16471:pin yi n =ka Case-16470 To-16466:pin yi n =kai Case-16465 To-16460:pin yi n =kan Case-16459 To-16453:pin yi n =kang Case-16452 To-16449:pin yi n =kao Case-16448 To-16434:pin yi n =ke Case-16433 To-16430:pin

18、yi n =ken Case-16429 To-16428:pin yi n =keng Case-16427 To-16424:pin yi n =kong Case-16423 To-16420:pin yi n =kou Case-16419 To -16413:pin yi n =ku Case -16412 To-16408:pin yi n =kua Case-16407 To-16404:pin yi n =kuai Case-16403 To-16402:pin yi n =kuan Case-16401 To-16394:pin yi n =kuang Case-16393

19、To-16221:pin yi n =kui Case-16220 To -16217:pin yi n =kun Case-16216 To -16213:pin yi n =kuo Case-16212 To-16206:pin yi n =la Case-16205 To-16203:pin yi n =lai Case-16202 To-16188:pin yi n =Ian Case-16187 To-16181:pin yi n =la ng Case-16180 To-16172:pin yi n =lao Case-16171 To-16170:pin yi n =le Cas

20、e-16169 To-16159:pin yi n =lei Case-16158 To-16156:pin yi n =le ng Case-16155 To-15960:pin yi n =li Case-15959 To-15959:pin yi n =lia Case-15958 To-15945:pin yi n =lian Case-15944 To-15934:pin yi n =lia ng Case-15933 To-15921:pin yi n =liao Case-15920 To-15916:pin yi n =lie Case-15915 To-15904:pin y

21、i n =lin Case-15903 To-15890:pin yi n =ling Case-15889 To-15879:pin yi n =liu Case-15878 To-15708:pin yi n =long Case-15707 To-15702:pin yi n =lou Case-15701 To-15682:pin yi n =lu Case-15681 To-15668:pin yi n =:lv Case-15667 To-15662:pin yi n =luan Case-15661 To-15660:pin yi n =lue Case-15659 To-156

22、53:pin yi n =lun Case-15652 To-15641:pin yi n =luo Case-15640 To-15632:pin yi n =ma Case-15631 To-15626:pin yi n =mai Case-15625 To-15455:pin yi n =ma n Case-15454 To-15449:pin yi n =ma ng Case-15448 To-15437:pin yi n =mao Case-15436 To-15436:pin yi n =me Case-15435 To-15420:pin yi n =mei Case-15419

23、 To-15417:pin yi n =me n Case-15416 To-15409:pin yi n =me ng Case-15408 To-15395:pin yi n =mi Case-15394 To-15386:pin yi n =mia n Case-15385 To-15378:pin yi n =miao Case-15377 To-15376:pin yi n =mie Case-15375 To-15370:pin yi n =min Case-15369 To-15364:pin yi n =mi ng Case-15363 To-15363:pin yi n =m

24、iu Case-15362 To-15184:pin yi n =mo Case-15183 To-15181:pin yi n =mou Case-15180 To-15166:pin yi n =mu Case-15165 To-15159:pin yi n =na Case-15158 To-15154:pin yi n =n ai Case-15153 To-15151:pin yi n =nan Case-15150 To-15150:pin yi n =nang Case -15149 To-15145:pin yi n =nao Case -15144 To-15144:pin yi n =ne Case -15143 To-15142:pin yi n =n ei Case-15141 To-15141:pin yi n =nen Case -15140 To -15140:pin yi n =neng Case-15139 To-15129:pin yi n =ni Case-15128 To-15122:pin yi n =n ia n