《如何在excel中把名字转化为邮箱》由会员分享，可在线阅读，更多相关《如何在excel中把名字转化为邮箱（15页珍藏版）》请在金锄头文库上搜索。
1、Excel自定义函数措施： 1启动xcel (其他版本请仿照操作),打开相应的工作表;2.执行“工具宏isua asic编辑器”命令(或者直接按“Alt11”组合键)，进入Visal Bi编辑状态； 3.执行“插入模块”命令,插入一种新模块。再双击插入的模块，进入模块代码编辑状态;.将代码输入其中；.代码输入完毕后，关闭isua asic编辑窗口,返回xcel编辑状态;6自定义函数就可以用了，如：选中D2单元格，输入公式：gety(2）。Function pn(p As Sing)s Sringi = Asc()Selt ase ise -01o 18: inyi Cae -2037 To-2
2、030：pinyin =a Case -304 To -2029: pni an Cs -20295 To -20293: pini= angas -20292To 284:pinyin = a Case-2283T -22： pnyn = baCase-20265 o -228: pinyin =ai Case -2057 T -20243: pinyn= ban Cae24To 023: pinyin = ang Case2230To -2：pinyi =ao Cae-1To -7: pnyn = bei ae - To -3： inyin = benCase -2 -7:pinyin =
3、 bengCase - T3: piyi bi Case - o -19991: pinyn ia Ca -19990 o -987: pnyin = bia Ca 196To -9983:piyi ie Case -19982 To -1997: pinibin as -996 To -1980: nyi bing Cse 105 o -19785: ini bo ae -9784T976: piyin = Cae 19775 To -9775: pin c Ce -1774 To-1764： inyi = ca Cse 19763 To -1757: pinyin cn ae 9756 T
4、o -972：in cang Case -19751 o19747: pinyn= a ase -1976T-1974: pinyi = e Cae -974 To -740: pinyin =ceng Ca 1939To 19729： pinn ch Ce -1928 -172: pnyin = chai ae -1925o -1976: iyin = chCase -1975 To-1951: pnyn =chang Cse -5 o -952:piny =chao Cse -1951 To-126: pny = he Cas-19525To -19516: piyi hen Case -
5、1515To -19501: piny = cng Case-195 To 45:pinyin = ch ase 19484 T -1948:pinyi= chong Case 1479 To -6: nyin cho ase 947 To-19290: inyn = chu Cas -19289 To-989: pnyn= chuai Cae 19288To -9282:pyin an Ca191 To -9276： pnyin = chuang ae -17 To-9271: nin= chui Case 1920 To 194: inyin = chn Case-23 To-19262：
6、 pinyi = chuo Cas 161 To19250: pinyin = ciCase 14 To -1924:pnin= c Case 1924 -19243: inyi = couCa 19242 To -1929: pinin = cu s-13To -1923: pnyin = cun Case -19235o 122： piin = uiCas 927 -19225: piyin cunse -1924 To -1919: pi cuo Case -1921 o1923： pinyn = da Cas 121 To-90: pnyin ai a -1903 To -94: in
7、in= dan as -23 T-119:pinyin =dng ae-101 To-190： nyin = dao Case -19006 To -190: piyin =de Cas-1900o -1899： pyn dnCase -189To 189:iin di Cae -18977 To-1862: pinyin ian ae-86 To-895: pinyin =dio Ca -952 T-1784: pinyin = deCas-18783 To -18775： pnyin = dig Case -8774 T -18774： pinyin= diu Cae 8773To -85
8、7: inyn = dongas 6 To-1859: nyn= f ase-1518 To 8502： pinyi= fa Cs -1501 To -1891:piin = fang Case -0 o -1479: nyn i Case 1848 To -18464:piny =fen Cae -1843To -1849: pinyn feg ase 448To -18448： inyi=fo Cs 8447To -1847: pini = fou as -1446 To-820： pnyin = u Ce -8239 To 18238:pii =ga Ca -18237 To -183:
9、 inyin = gaCe -1231To -82: pinyin = an Case -182o -82： pinyin = gag Cse-211To -8202:inyin o as -12 To -181: piy= ge ase -1884 T -1884: pinyin gei Cse 813T-1882:inn = g Case -1881 To -180: inin = gen Case -18012 To -79: piin = gong Case-17997 To -799: pinyin = ou Cas178To7971: pinyn = guase -790T1796
10、5: pinyin= guaCse 1794 o 76: pin = ua Ce 17961To-1791： nyin =guanCase -1790 To-1794: inyin uang Case -17 -17932： piyin = gui Case-1731To 17929: inin gun Case -1728To -1793:pnyin =go ase 792 To -1760: pinyi = ha Cae-175 To 17753：iin = hi Cae -7752 To -17734: pinyin =hnCase -7733 To -17731:pinyihang C
11、e -17730 T -17722：pny =haoCas -17721 T-704: pinyin= he Case -703 o -1702: pnyin = hei Cse -1771 o -1769: inyn= hn ase -17697 o -1763:i=hngas -17692 To18： pinyin =hn Cae 17683T 1677： pi= hou Cae-776 To -97: pny = h se -46T-1748： pnyin =hua Cae -748 To 17483: pyin = uai Cae -142 To 146: pyn = hun Case -17468To-5: pini= uag Cse -1454To -1744: piy= hiCse-173T 1748: piyin hun Cae-17427 To -171: inin = huo Cse 17417 To -17203: piyin = jiCse -120 To 1716:piy =jia
