(完整版)Excel自定義函數(shù)方法拼音

Excel自定義函數(shù)方法：啟動Excel2003（其它版本請仿照操作），打開相應(yīng)的工作表；執(zhí)行“工具一宏一VisualBasic編輯器”命令（或者直接按“Alt+F11”組合鍵），進(jìn)入VisualBasic編輯狀態(tài)；執(zhí)行“插入一模塊”命令，插入一個新模塊。再雙擊插入的模塊，進(jìn)入模塊代碼編輯狀態(tài)；將代碼輸入其中；代碼輸入完成后，關(guān)閉VisualBasic編輯窗口，返回Excel編輯狀態(tài)；6.自定義函數(shù)就可以用了，如：選中D2單元格，輸入公式：=getpy（A2）有極個別的漢字不能轉(zhuǎn)換，手動就可以了！很方便了。Functionpinyin(pAsString)AsStringi=Asc(p)SelectCaseiCase-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-20037pinyin=“bei”Case-20036To-20033pinyin=“ben”Case-20032To-20027pinyin=“beng”Case-20026To-20003pinyin=“bi”Case-20002To-19991pinyin=“bian”Case-19990To-19987pinyin=“biao”Case-19986To-19983pinyin=“bie”Case-19982To-19977pinyin=“bin”Case-19976To-19806pinyin=“bing”Case-19805To-19785pinyin=“bo”Case-19784To-19776pinyin=“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-19740pinyin=“ceng”Case-19739To-19729:pinyin=“cha”Case-19728To-19726:pinyin=“chai”Case-19500To-19485:pinyin=“chi”Case-19484To-19480pinyin=“chong”Case-19479To-19468:pinyin=“chou”Case-19467To-19290:pinyin=“chu”Case-19289To-19289:pinyin=“chuai”Case-19288To-19282:pinyin=“chuan”Case-19281To-19276pinyin=“chuang”Case-19275To-19271:pinyin=“chui”Case-19270To-19264:pinyin=“chun”Case-19263To-19262:pinyin=“chuo”Case-19261To-19250:pinyin=“ci”Case-19249To-19244pinyin=“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”CaseCase-19038To-19024Case-19023To-19019Case-19018To-19007Case-19006To-19004Case-19003To-18997CaseCase-17947To-17932Case-17931To-17929Case-17928To-17923Case-17922To-17760Case-17759To-17753Case-17752To-17734Case-17733To-17731CaseCase-18996To-18978Case-18977To-18962Case-18961To-18953Case-18952To-18784Case-18783To-18775Case-18774To-18774Case-18773To-18527Case-18526To-18519Case-18518To-18502Case-18501To-18491Case-18490To-18479Case-18478To-18464Case-18463To-18449Case-18448To-18448Case-18447To-18447Case-18446To-18240Case-18239To-18238Case-18237To-18232Case-18231To-18221Case-18220To-18212Case-18211To-18202Case-18201To-18185Case-18184To-18184Case-18183To-18182Case-18181To-18013Case-18012To-17998Case-17997To-17989Case-17988To-17971Case-17970To-17965Case-17964To-17962Case-17961To-17951Case-17950To-17948pinyin=“dan”pinyin=“dang”pinyin=“dao”pinyin=“de”pinyin=“deng”pinyin=“di”pinyin=“dian”pinyin=“diao”pinyin=“die”pinyin=“ding”pinyin=“diu”pinyin=“dong”pinyin=“fa”pinyin=“fan”pinyin=“fang”pinyin=“fei”pinyin=“fen”pinyin=“feng”pinyin=“fo”pinyin=“fou”pinyin=“fu”pinyin=“ga”pinyin=“gai”pinyin=“gan”pinyin=“gang”pinyin=“gao”pinyin=“ge”pinyin=“gei”pinyin=“gen”pinyin=“geng”pinyin=“gong”pinyin=“gou”pinyin=“gu”pinyin=“gua”pinyin=“guai”pinyin=“guan”pinyin=“guang”pinyin=“gui”pinyin=“gun”pinyin=“guo”pinyin=“ha”pinyin=“hai”pinyin=“han”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”Case-17417To-17203:pinyin=“ji”Case-17202To-17186:pinyin=“jia”Case-17185To-16984:pinyin=“jian”Case-16983To-16971:pinyin=“jiang”Case-16970To-16943:pinyin=“jiao”Case-16942To-16916:pinyin=“jie”Case-16915To-16734:pinyin=“jin”Case-16733To-16709:pinyin=“jing”Case-16708To-16707:pinyin=“jiong”Case-16706To-16690:pinyin=“jiu”Case-16689To-16665:pinyin=“ju”Case-16664To-16658:pinyin=“juan”Case-16657To-16648:pinyin=“jue”Case-16647To-16475:pinyin=“jun”Case-16474To-16471:pinyin=“ka”Case-16470To-16466:pinyin=“kai”Case-16465To-16460:pinyin=“kan”Case-16459To-16453:pinyin=“kang”Case-16452To-16449:pinyin=“kao”Case-16448To-16434:pinyin=“ke”Case-16433To-16430:pinyin=“ken”Case-16429To-16428:pinyin=“keng”Case-16427To-16424:pinyin=“kong”Case-16423To-16420:pinyin=“kou”Case-16419To-16413:pinyin=“ku”Case-16412To-16408:pinyin=“kua”Case-16407To-16404:pinyin=“kuai”Case-16403To-16402:pinyin=“kuan”Case-16401To-16394:pinyin=“kuang”CaseCase-15362To-15184:pinyinCase-15183To-15181:pinyinCase-15180To-15166:pinyinCase-15165To-15159:pinyinCase-15158To-15154:pinyinCaseCase-16393To-16221Case-16220To-16217Case-16216To-16213Case-16212To-16206Case-16205To-16203CaseCase-14678To-14675:pinyinCase-14674To-14671:pinyinCase-14670To-14669:pinyinCase-14668To-14664:pinyinCase-14663To-14655:pinyinCase-14654To-14646:pinyinCase-14645To-14631:pinyinCaseCase-15408To-15395Case-15394To-15386Case-15385To-15378Case-15377To-15376Case-15375To-15370Case-15369To-15364Case-15363To-15363Case-16202To-16188Case-16187To-16181Case-16180To-16172Case-16171To-16170Case-16169To-16159Case-16158To-16156Case-16155To-15960Case-15959To-15959Case-15958To-15945Case-15944To-15934Case-15933To-15921Case-15920To-15916Case-15915To-15904Case-15903To-15890Case-15889To-15879Case-15878To-15708Case-15707To-15702Case-15701To-15682Case-15681To-15668Case-15667To-15662Case-15661To-15660Case-15659To-15653Case-15652To-15641Case-15640To-15632Case-15631To-15626Case-15625To-15455Case-15454To-15449Case-15448To-15437Case-15436To-15436Case-15435To-15420Case-15419To-15417pinyin=“kui”pinyin=“kun”pinyin=“kuo”pinyin=“l(fā)a”pinyin=“l(fā)ai”pinyin=“l(fā)an”pinyin=“l(fā)ang”pinyin=“l(fā)ao”pinyin=“l(fā)e”pinyin=“l(fā)ei”pinyin=“l(fā)eng”pinyin=“l(fā)i”pinyin=“l(fā)ia”pinyin=“l(fā)ian”pinyin=“l(fā)iang”pinyin=“l(fā)iao”pinyin=“l(fā)ie”pinyin=“l(fā)in”pinyin=“l(fā)ing”pinyin=“l(fā)iu”pinyin=“l(fā)ong”pinyin=“l(fā)ou”pinyin=“l(fā)u”pinyin=“l(fā)v”pinyin=“l(fā)uan”pinyin=“l(fā)ue”pinyin=“l(fā)un”pinyin=“l(fā)uo”pinyin=“ma”pinyin=“mai”pinyin=“man”pinyin=“mang”pinyin=“mao”pinyin=“me”pinyin=“mei”pinyin=“men”pinyin=“meng”pinyin=“mi”pinyin=“mian”pinyin=“miao”pinyin=“mie”pinyin=“min”pinyin=“ming”pinyin=“miu”Case-15416To-15409

pinyin=“kui”pinyin=“kun”pinyin=“kuo”pinyin=“l(fā)a”pinyin=“l(fā)ai”pinyin=“l(fā)an”pinyin=“l(fā)ang”pinyin=“l(fā)ao”pinyin=“l(fā)e”pinyin=“l(fā)ei”pinyin=“l(fā)eng”pinyin=“l(fā)i”pinyin=“l(fā)ia”pinyin=“l(fā)ian”pinyin=“l(fā)iang”pinyin=“l(fā)iao”pinyin=“l(fā)ie”pinyin=“l(fā)in”pinyin=“l(fā)ing”pinyin=“l(fā)iu”pinyin=“l(fā)ong”pinyin=“l(fā)ou”pinyin=“l(fā)u”pinyin=“l(fā)v”pinyin=“l(fā)uan”pinyin=“l(fā)ue”pinyin=“l(fā)un”pinyin=“l(fā)uo”pinyin=“ma”pinyin=“mai”pinyin=“man”pinyin=“mang”pinyin=“mao”pinyin=“me”pinyin=“mei”pinyin=“men”pinyin=“meng”pinyin=“mi”pinyin=“mian”pinyin=“miao”pinyin=“mie”pinyin=“min”pinyin=“ming”pinyin=“miu”Case-15153To-15151:pinyinCase-15150To-15150:pinyinCase-15149To-15145:pinyinCase-15144To-15144:pinyinCase-15143To-15142:pinyinCase-15141To-15141:pinyinCase-15140To-15140:pinyinCase-15139To-15129:pinyinCase-15128To-15122:pinyinCase-15121To-15120:pinyinCase-15119To-15118:pinyinCase-15117To-15111:pinyinCase-15110To-15110:pinyinCase-15109To-14942:pinyinCase-14941To-14938:pinyinCase-14937To-14934:pinyinCase-14933To-14931:pinyinCase-14930To-14930:pinyinCase-14929To-14929:pinyinCase-14928To-14927:pinyinCase-14926To-14923:pinyinCase-14922To-14922:pinyinCase-14921To-14915:pinyinCase-14914To-14909:pinyinCase-14908To-14903:pinyinCase-14902To-14895:pinyinCase-14894To-14890:pinyinCase-14889To-14883:pinyinCase-14882To-14874:pinyinCase-14873To-14872:pinyinCase-14871To-14858:pinyin“mo”“mou”“mu”“na”“nai”“nan”“nang”"Sf亠〃“nao”“ne”“nei”“nen”“neng”“ni”“nian”//?))“niang”“niao”“nie”“nin”“ning”“niu”“nong”“nu”“nv”“nuan”“nue”“nuo”“o”“ou”“pa”“pai”“pan”“pang”“pao”“pei”“pen”“peng”“pi”“pian”“piao”“pie”“pin”“ping”“po”“pu”“mo”“mou”“mu”“na”“nai”“nan”“nang”"Sf亠〃“nao”“ne”“nei”“nen”“neng”“ni”“nian”//?))“niang”“niao”“nie”“nin”“ning”“niu”“nong”“nu”“nv”“nuan”“nue”“nuo”“o”“ou”“pa”“pai”“pan”“pang”“pao”“pei”“pen”“peng”“pi”“pian”“piao”“pie”“pin”“ping”“po”“pu”CaseCase-14630To-14595Case-14594To-14430Case-14429To-14408Case-14407To-14400Case-14399To-14385CaseCase-13896To-13895Case-13894To-13879Case-13878To-13871Case-13870To-13860Case-13859To-13848Case-13847To-13832Case-13831To-13659Case-14384To-14380Case-14379To-14369Case-14368To-14356Case-14355To-14354Case-14353To-14346Case-14345To-14171Case-14170To-14160Case-14159To-14152Case-14151To-14150Case-14149To-14146Case-14145To-14141Case-14140To-14138Case-14137To-14136Case-14135To-14126Case-14125To-14124Case-14123To-14123Case-14122To-14113Case-14112To-14110Case-14109To-14100Case-14099To-14098Case-14097To-14095Case-14094To-14093Case-14092To-14091Case-14090To-14088Case-14087To-14084Case-14083To-13918Case-13917To-13915Case-13914To-13911Case-13910To-13908Case-13907To-13907Case-13906To-13906pinyin=“qi”pinyin=“qia”pinyin=“qian”pinyin=“qiang”pinyin=“qiao”pinyin=“qie”pinyin=“qin”pinyin=“qing”pinyin=“qiong”pinyin=“qiu”pinyin=“qu”pinyin=“quan”pinyin=“que”pinyin=“qun”pinyin=“ran”pinyin=“rang”pinyin=“rao”pinyin=“re”pinyin=“ren”pinyin=“reng”pinyin=“ri”pinyin=“rong”pinyin=“rou”pinyin=“ru”pinyin=“ruan”pinyin=“rui”pinyin=“run”pinyin=“ruo”pinyin=“sa”pinyin=“sai”pinyin=“san”pinyin=“sang”pinyin=“sao”pinyin=“se”pinyin=“sen”pinyin=“seng”pinyin=“sha”pinyin=“shai”pinyin=“shan”pinyin=“shang”pinyin=“shao”pinyin=“she”pinyin=“shen”pinyin=“sheng”Case-13905To-13897pinyin=“qi”pinyin=“qia”pinyin=“qian”pinyin=“qiang”pinyin=“qiao”pinyin=“qie”pinyin=“qin”pinyin=“qing”pinyin=“qiong”pinyin=“qiu”pinyin=“qu”pinyin=“quan”pinyin=“que”pinyin=“qun”pinyin=“ran”pinyin=“rang”pinyin=“rao”pinyin=“re”pinyin=“ren”pinyin=“reng”pinyin=“ri”pinyin=“rong”pinyin=“rou”pinyin=“ru”pinyin=“ruan”pinyin=“rui”pinyin=“run”pinyin=“ruo”pinyin=“sa”pinyin=“sai”pinyin=“san”pinyin=“sang”pinyin=“sao”pinyin=“se”pinyin=“sen”pinyin=“seng”pinyin=“sha”pinyin=“shai”pinyin=“shan”pinyin=“shang”pinyin=“shao”pinyin=“she”pinyin=“shen”pinyin=“sheng”CaseCase-13658To-13612Case-13611To-13602Case-13601To-13407Case-13406To-13405Case-13404To-13401CaseCase-12838To-12832Case-12831To-12830Case-12829To-12813Case-12812To-12803Case-12802To-12608Case-12607To-12598Case-12597To-12595CaseCase-13400To-13399Case-13398To-13396Case-13395To-13392Case-13391To-13388Case-13387To-13384Case-13383To-13368Case-13367To-13360Case-13359To-13357Case-13356To-13344Case-13343To-13341Case-13340To-13330Case-13329To-13327Case-13326To-13319Case-13318To-13148Case-13147To-13139Case-13138To-13121Case-13120To-13108Case-13107To-13097Case-13096To-13096Case-13095To-13092Case-13091To-13077Case-13076To-13069Case-13068To-13064Case-13063To-13061Case-13060To-12889Case-12888To-12876Case-12875To-12872Case-12871To-12861Case-12860To-12859Case-12858To-12853Case-12852To-12850Case-12849To-12839pinyin=“shi”pinyin=“shou”pinyin=“shu”pinyin=“shua”pinyin=“shuai”pinyin=“shuan”pinyin=“shuang”pinyin=“shui”pinyin=“shun”pinyin=“shuo”pinyin=“si”pinyin=“song”pinyin=“sou”pinyin=“su”pinyin=“suan”pinyin=“sui”pinyin=“sun”pinyin=“suo”pinyin=“ta”pinyin=“tai”pinyin=“tan”pinyin=“tang”pinyin=“tao”pinyin=“te”pinyin=“teng”pinyin=“ti”pinyin=“tian”pinyin=“tiao”pinyin=“tie”pinyin=“ting”pinyin=“tong”pinyin=“tou”pinyin=“tu”pinyin=“tuan”pinyin=“tui”pinyin=“tun”pinyin=“tuo”pinyin=“wa”pinyin=“wai”pinyin=“wan”pinyin=“wang”pinyin=“wei”pinyin=“wen”pinyin=“weng”CaseCase-12594To-12586Case-12585To-12557Case-12556To-12360Case-12359To-12347Case-12346To-12321CaseCase-11020To-11020Case-11019To-11019Case-11018To-11015Case-11014To-10839Case-10838To-10833Case-10832To-10816Case-10815To-10801Case-12320To-12301Case-12300To-12121Case-12120To-12100Case-12099To-12090Case-12089To-12075Case-12074To-12068Case-12067To-12059Case-12058To-12040Case-12039To-11868Case-11867To-11862Case-11861To-11848Case-11847To-11832Case-11831To-11799Case-11798To-11782Case-11781To-11605Case-11604To-11590Case-11589To-11537Case-11536To-11359Case-11358To-11341Case-11340To-11340Case-11339To-11325Case-11324To-11304Case-11303To-11098Case-11097To-11078Case-11077To-11068Case-11067To-11056Case-11055To-11053Case-11052To-11046Case-11045To-11042Case-11041To-11039Case-11038To-11025pinyin=“wo”pinyin=“wu”pinyin=“xi”pinyin=“xia”pinyin=“xian”pinyin=“xiang”pinyin=“xiao”pinyin=“xie”pinyin=“xin”pinyin=“xing”pinyin=“xiong”pinyin=“xiu”pinyin=“xu”pinyin=“xuan”pinyin=“xue”pinyin=“xun”pinyin=“ya”pinyin=“yan”pinyin=“yang”pinyin=“yao”pinyin=“ye”pinyin=“yi”pinyin=“yin”pinyin=“ying”pinyin=“yo”pinyin=“yong”pinyin=“you”pinyin=“yu”pinyin=“yuan”pinyin=“yue”pinyin=“yun”pinyin=“za”pinyin=“zai”pinyin=“zan”pinyin=“zang”pinyin=“zao”pinyin=“ze”pinyin=“zei”pinyin=“zen”pinyin=“zeng”pinyin=“zha”pinyin=“zhai”pinyin=“zhan”pinyin=“zhang”Case-11024To-11021pinyin=“wo”pinyin=“wu”pinyin=“xi”pinyin=“xia”piny