搜索
Excel自定义函数方法：1.启动Excel2003（其它版本请仿照操作），打开相应的工作表；2.执行“工具→宏→VisualBasic编辑器”命令（或者直接按“Alt+F11”组合键），进入VisualBasic编辑状态；3.执行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态；4.将代码输入其中；5.代码输入完成后，关闭VisualBasic编辑窗口，返回Excel编辑状态；6.自定义函数就可以用了，如：选中D2单元格，输入公式：=getpy(A2)。有极个别的汉字不能转换，手动就可以了！很方便了。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-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-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”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”Case-16393To-16221:pinyin=“kui”Case-16220To-16217:pinyin=“kun”Case-16216To-16213:pinyin=“kuo”Case-16212To-16206:pinyin=“la”Case-16205To-16203:pinyin=“lai”Case-16202To-16188:pinyin=“lan”Case-16187To-16181:pinyin=“lang”Case-16180To-16172:pinyin=“lao”Case-16171To-16170:pinyin=“le”Case-16169To-16159:pinyin=“lei”Case-16158To-16156:pinyin=“leng”Case-16155To-15960:pinyin=“li”Ca