Excel自定义函数方法：1启动Excel2003（其它版本请仿照操作），打开相应的工作表；
2执行“工具→宏→VisualBasic编辑器”命令（或者直接按“AltF11”组合键），进入VisualBasic编辑状态；
3执行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态；
4将代码输入其中；
5代码输入完成后，关闭VisualBasic编辑窗口，返回Excel编辑状态；
6自定义函数就可以用了，如：选中D2单元格，输入公式：getpyA2。
有极个别的汉字不能转换，手动就可以了！很方便了。
Fu
ctio
pi
yi
pAsStri
gAsStri
giAscpSelectCaseiCase20319To20318pi
yi
“a”Case20317To20305pi
yi
“ai”Case20304To20296pi
yi
“a
”Case20295To20293pi
yi
“a
g”Case20292To20284pi
yi
“ao”Case20283To20266pi
yi
“ba”Case20265To20258pi
yi
“bai”Case20257To20243pi
yi
“ba
”Case20242To20231pi
yi
“ba
g”Case20230To20052pi
yi
“bao”
fCase20051To20037pi
yi
“bei”Case20036To20033pi
yi
“be
”Case20032To20027pi
yi
“be
g”Case20026To20003pi
yi
“bi”Case20002To19991pi
yi
“bia
”Case19990To19987pi
yi
“biao”Case19986To19983pi
yi
“bie”Case19982To19977pi
yi
“bi
”Case19976To19806pi
yi
“bi
g”Case19805To19785pi
yi
“bo”Case19784To19776pi
yi
“bu”Case19775To19775pi
yi
“ca”Case19774To19764pi
yi
“cai”Case19763To19757pi
yi
“ca
”Case19756To19752pi
yi
“ca
g”Case19751To19747pi
yi
“cao”Case19746To19742pi
yi
“ce”Case19741To19740pi
yi
“ce
g”Case19739To19729pi
yi
“cha”Case19728To19726pi
yi
“chai”
Case19500To19485pi
yi
“chi”Case19484To19480pi
yi
“cho
g”Case19479To19468pi
yi
“chou”Case19467To19290pi
yi
“chu”Case19289To19289pi
yi
“chuai”Case19288To19282pi
yi
“chua
”Case19281To19276pi
yi
“chua
g”Case19275To19271pi
yi
“chui”Case19270To19264pi
yi
“chu
”Case19263To19262pi
yi
“chuo”Case19261To19250pi
yi
“ci”Case19249To19244pi
yi
“co
g”Case19243To19243pi
yi
“cou”Case19242To19239pi
yi
“cu”Case19238To19236pi
yi
“cua
”Case19235To19228pi
yi
“cui”Case19227To19225pi
yi
“cu
”Case19224To19219pi
yi
“cuo”Case19218To19213pi
yi
“da”Case19212To19039pi
yi
“dai”
fCase19038To19024pi
yi
“da
”Case19023To19019pi
yi
“da
g”Case19018To19007pi
yi
“dao”Case19006To19004pi
yi
“de”Case19003To18997pi
yi
“de
g”Cr