HR人士要掌握的EXCEL汉字转拼音方法及步骤.docVIP

HR人士要掌握的EXCEL汉字转拼音方法及步骤 HR人士在工作中管理员工的数据，如果是在欧美外企，因为国外总部通常会需要将汉字员工的信息转换成拼音，将这些信息录入存储在人事系统中，或者以人事报表形式将拼音信息汇报给总部。因为员工数据通常会用EXCEL统计，掌握EXCEL汉字转拼音，会大大提高办公效率。 最常用的操作是员工姓名，家属姓名汉字转拼音等。下面以名字的转换为例子， 介绍EXCEL中汉字转拼音方法的两个主要步骤： * 在EXCEL中设定汉字转拼音的自定义函数 = Pinyin(). * 通过EXCEL中自带函数 与 自己设定的汉字转拼音自定义函数组合，将目标汉字转换成拼音，再复制粘贴保存到合适位置。 Excel中设定自定义函数= Pinyin().的步骤： 1.新建一个新的 Excel文件，打开显示出工作表； 2.按“Alt+F11”组合键，进入Visual Basic编辑状态； 3.再按“F7”键，进入模块代码编辑状态； 4.将下面的代码，复制粘贴到模块代码编辑中； Function PinYin(Hz As String)Dim PinMa As StringDim MyPinMa As VariantDim Temp As Integer, i As Integer, j As IntegerPinMa = a,20319,ai,20317,an,20304,ang,20295,ao,20292,PinMa = PinMa ba,20283,bai,20265,ban,20257,bang,20242,bao,20230,bei,20051,ben,20036,beng,20032,bi,20026,bian,20002,biao,19990,bie,19986,bin,19982,bing,19976,bo,19805,bu,19784,PinMa = PinMa ca,19775,cai,19774,can,19763,cang,19756,cao,19751,ce,19746,ceng,19741,cha,19739,chai,19728,chan,19725,chang,19715,chao,19540,che,19531,chen,19525,cheng,19515,chi,19500,chong,19484,chou,19479,chu,19467,chuai,19289,chuan,19288,chuang,19281,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,cou,19243,cu,19242,cuan,19238,cui,19235,cun,19227,cuo,19224,PinMa = PinMa da,19218,dai,19212,dan,19038,dang,19023,dao,19018,de,19006,deng,19003,di,18996,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,18773,dou,18763,du,18756,duan,18741,dui,18735,dun,18731,duo,18722,PinMa = PinMa e,18710,en,18697,er,18696,PinMa = PinMa fa,18526,fan,18518,fang,18501,fei,18490,fen,18478,feng,18463,fo,18448,fou,18447,fu,18446,PinMa = PinMa ga,18239,gai,18237,gan,18231,gang,18220,gao,18211,ge,18201,gei,18184,gen,18183,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,17964,guan,17961,guang,17950,gui,17947,gun,17931,guo,17928,PinMa = PinMa ha,17922,hai,17759,han,17752,hang,17733,hao,17730,he,17721,hei,17703,hen,17701,heng,17697,hong,17692,hou,17683,hu,17676,hua,17496,huai,17487,huan,17482,huang,17468,hui,17454,hun,17433,huo,17427,PinMa = PinMa ji,17417,jia,17202,jian,17185,j