如何在excel中把名字转化为邮箱.docx

如何在excel中把名字转化为邮箱.docx

《如何在excel中把名字转化为邮箱.docx》由会员分享，可在线阅读，更多相关《如何在excel中把名字转化为邮箱.docx（14页珍藏版）》请在冰豆网上搜索。

如何在excel中把名字转化为邮箱

如何在excel中把名字转化为邮箱

Excel自定义函数方法：

　　1.启动Excel2003（其它版本请仿照操作），打开相应的工作表；

　　2.执行“工具→宏→VisualBasic编辑器”命令（或者直接按“Alt+F11”组合键），进入VisualBasic编辑状态；

　　3.执行“插入→模块”命令，插入一个新模块。

再双击插入的模块，进入模块代码编辑状态；

　　4.将代码输入其中；

　　5.代码输入完成后，关闭VisualBasic编辑窗口，返回Excel编辑状态；

6.自定义函数就可以用了，如：

选中D2单元格，输入公式：

=getpy（A2）。

Functionpinyin（pAsString）AsString

i=Asc（p）

SelectCasei

Case-20319To-20318:

pinyin="a"

Case-20317To-20305:

pinyin="ai"

Case-20304To-20296:

pinyin="an"

Case-20295To-20293:

pinyin="ang"

Case-20292To-20284:

pinyin="ao"

Case-20283To-20266:

pinyin="ba"

Case-20265To-20258:

pinyin="bai"

Case-20257To-20243:

pinyin="ban"

Case-20242To-20231:

pinyin="bang"

Case-20230To-20052:

pinyin="bao"

Case-20051To-20037:

pinyin="bei"

Case-20036To-20033:

pinyin="ben"

Case-20032To-20027:

pinyin="beng"

Case-20026To-20003:

pinyin="bi"

Case-20002To-19991:

pinyin="bian"

Case-19990To-19987:

pinyin="biao"

Case-19986To-19983:

pinyin="bie"

Case-19982To-19977:

pinyin="bin"

Case-19976To-19806:

pinyin="bing"

Case-19805To-19785:

pinyin="bo"

Case-19784To-19776:

pinyin="bu"

Case-19775To-19775:

pinyin="ca"

Case-19774To-19764:

pinyin="cai"

Case-19763To-19757:

pinyin="can"

Case-19756To-19752:

pinyin="cang"

Case-19751To-19747:

pinyin="cao"

Case-19746To-19742:

pinyin="ce"

Case-19741To-19740:

pinyin="ceng"

Case-19739To-19729:

pinyin="cha"

Case-19728To-19726:

pinyin="chai"

Case-19725To-19716:

pinyin="chan"

Case-19715To-19541:

pinyin="chang"

Case-19540To-19532:

pinyin="chao"

Case-19531To-19526:

pinyin="che"

Case-19525To-19516:

pinyin="chen"

Case-19515To-19501:

pinyin="cheng"

Case-19500To-19485:

pinyin="chi"

Case-19484To-19480:

pinyin="chong"

Case-19479To-19468:

pinyin="chou"

Case-19467To-19290:

pinyin="chu"

Case-19289To-19289:

pinyin="chuai"

Case-19288To-19282:

pinyin="chuan"

Case-19281To-19276:

pinyin="chuang"

Case-19275To-19271:

pinyin="chui"

Case-19270To-19264:

pinyin="chun"

Case-19263To-19262:

pinyin="chuo"

Case-19261To-19250:

pinyin="ci"

Case-19249To-19244:

pinyin="cong"

Case-19243To-19243:

pinyin="cou"

Case-19242To-19239:

pinyin="cu"

Case-19238To-19236:

pinyin="cuan"

Case-19235To-19228:

pinyin="cui"

Case-19227To-19225:

pinyin="cun"

Case-19224To-19219:

pinyin="cuo"

Case-19218To-19213:

pinyin="da"

Case-19212To-19039:

pinyin="dai"

Case-19038To-19024:

pinyin="dan"

Case-19023To-19019:

pinyin="dang"

Case-19018To-19007:

pinyin="dao"

Case-19006To-19004:

pinyin="de"

Case-19003To-18997:

pinyin="deng"

Case-18996To-18978:

pinyin="di"

Case-18977To-18962:

pinyin="dian"

Case-18961To-18953:

pinyin="diao"

Case-18952To-18784:

pinyin="die"

Case-18783To-18775:

pinyin="ding"

Case-18774To-18774:

pinyin="diu"

Case-18773To-18527:

pinyin="dong"

Case-18526To-18519:

pinyin="fa"

Case-18518To-18502:

pinyin="fan"

Case-18501To-18491:

pinyin="fang"

Case-18490To-18479:

pinyin="fei"

Case-18478To-18464:

pinyin="fen"

Case-18463To-18449:

pinyin="feng"

Case-18448To-18448:

pinyin="fo"

Case-18447To-18447:

pinyin="fou"

Case-18446To-18240:

pinyin="fu"

Case-18239To-18238:

pinyin="ga"

Case-18237To-18232:

pinyin="gai"

Case-18231To-18221:

pinyin="gan"

Case-18220To-18212:

pinyin="gang"

Case-18211To-18202:

pinyin="gao"

Case-18201To-18185:

pinyin="ge"

Case-18184To-18184:

pinyin="gei"

Case-18183To-18182:

pinyin="gen"

Case-18181To-18013:

pinyin="geng"

Case-18012To-17998:

pinyin="gong"

Case-17997To-17989:

pinyin="gou"

Case-17988To-17971:

pinyin="gu"

Case-17970To-17965:

pinyin="gua"

Case-17964To-17962:

pinyin="guai"

Case-17961To-17951:

pinyin="guan"

Case-17950To-17948:

pinyin="guang"

Case-17947To-17932:

pinyin="gui"

Case-17931To-17929:

pinyin="gun"

Case-17928To-17923:

pinyin="guo"

Case-17922To-17760:

pinyin="ha"

Case-17759To-17753:

pinyin="hai"

Case-17752To-17734:

pinyin="han"

Case-17733To-17731:

pinyin="hang"

Case-17730To-17722:

pinyin="hao"

Case-17721To-17704:

pinyin="he"

Case-17703To-17702:

pinyin="hei"

Case-17701To-17698:

pinyin="hen"

Case-17697To-17693:

pinyin="heng"

Case-17692To-17684:

pinyin="hong"

Case-17683To-17677:

pinyin="hou"

Case-17676To-17497:

pinyin="hu"

Case-17496To-17488:

pinyin="hua"

Case-17487To-17483:

pinyin="huai"

Case-17482To-17469:

pinyin="huan"

Case-17468To-17455:

pinyin="huang"

Case-17454To-17434:

pinyin="hui"

Case-17433To-17428:

pinyin="hun"

Case-17427To-17418:

pinyin="huo