宏-汉字转换拼音
汉字转拼音(宏)下载
因为上传规则，不能上传启用宏文件，使用者在使用前打开要转换成拼音的excel表格。
按“ A插入一个新模块。
再双击插入的模块，进入模块代码编辑状态。
把下面代码复制到模块编辑块中，保存。
关闭exc 后按汉字转拼音函数即可操作。
因字库原因，部分汉字不可转。
Functionpinyin(pAsString)AsStringi =Asc(p)SelectCase iCase -20319 To-20318:pinyin ="a "Case -20317 To-20305:pinyin ="ai "Case -20304 To-20296:pinyin ="an "Case -20295 To-20293:pinyin ="ang "Case -20292 To-20284:pinyin ="ao "Case -20283 To-20266:pinyin =pinyin = "bai "Case -20257 To -20243: pinyin = "ban "Case -20242 To -20231: pinyin = "bang " Case -20230 To -20052: pinyin = "bao "Case -20051 To -20037: pinyin = "bei " Case -20036 To -20033: pinyin = "ben "Case -20032 To -20027: pinyin = "beng " Case -20026 To -20003: pinyin = "bi "Case -20002 To -19991: pinyin =pinyin = "biao "Case -19986 To -19983: pinyin = "bie "Case -19982 To -19977: pinyin = "bin " Case -19976 To -19806: pinyin = "bing "Case -19805 To -19785: pinyin = "bo " Case -19784 To -19776: pinyin = "bu "Case -19775 To -19775: pinyin = "ca " Case -19774 To -19764: pinyin = "cai "Case -19763 To -19757: pinyin =pinyin = "cang "Case -19751 To -19747: pinyin = "cao "Case -19746 To -19742: pinyin = "ce " Case -19741 To -19740: pinyin = "ceng "Case -19739 To -19729: pinyin = "cha " Case -19728 To -19726: pinyin = "chai "Case -19725 To -19716: pinyin = "chan " Case -19715 To -19541: pinyin = "chang "Case -19540 To -19532: pinyin =pinyin = "che "Case -19525 To -19516: pinyin = "chen "Case -19515 To -19501: pinyin = "cheng " Case -19500 To -19485: pinyin = "chi "Case -19484 To -19480: pinyin = "chong " Case -19479 To -19468: pinyin = "chou "Case -19467 To -19290: pinyin = "chu " Case -19289 To -19289: pinyin = "chuai "Case -19288 To -19282: pinyin =pinyin = "chuang "Case -19275 To -19271: pinyin = "chui "Case -19270 To -19264: pinyin = "chun "Case -19263 To -19262: pinyin = "chuo " Case -19261 To -19250: pinyin = "ci "Case -19249 To -19244: pinyin = "cong " Case -19243 To -19243: pinyin = "cou "Case -19242 To -19239: pinyin = "cu " Case -19238 To -19236:-19228: pinyin = "cui "Case -19227 To -19225: pinyin = "cun "Case -19224 To -19219: pinyin = "cuo " Case -19218 To -19213: pinyin = "da "Case -19212 To -19039: pinyin = "dai " Case -19038 To -19024: pinyin = "dan "Case -19023 To -19019: pinyin = "dang " Case -19018 To -19007: pinyin = "dao "Case -19006 To -19004:-18997: pinyin = "deng "Case -18996 To -18978: pinyin = "di "Case -18977 To -18962: pinyin = "dian " Case -18961 To -18953: pinyin = "diao "Case -18952 To -18784: pinyin = "die " Case -18783 To -18775: pinyin = "ding "Case -18774 To -18774: pinyin = "diu " Case -18773 To -18527: pinyin = "dong "Case -18526 To -18519:-18502: pinyin = "fan "Case -18501 To -18491: pinyin = "fang "Case -18490 To -18479: pinyin = "fei " Case -18478 To -18464: pinyin = "fen "Case -18463 To -18449: pinyin = "feng " Case -18448 To -18448: pinyin = "fo "Case -18447 To -18447: pinyin = "fou " Case -18446 To -18240: pinyin = "fu "Case -18239 To -18238:-18232: pinyin = "gai "Case -18231 To -18221: pinyin = "gan "Case -18220 To -18212: pinyin = "gang " Case -18211 To -18202: pinyin = "gao "Case -18201 To -18185: pinyin = "ge " Case -18184 To -18184: pinyin = "gei "Case -18183 To -18182: pinyin = "gen " Case -18181 To -18013: pinyin = "geng "Case -18012 To -17998:-17989: pinyin = "gou "Case -17988 To -17971: pinyin = "gu "Case -17970 To -17965: pinyin = "gua " Case -17964 To -17962: pinyin = "guai "Case -17961 To -17951: pinyin = "guan " Case -17950 To -17948: pinyin = "guang "Case -17947 To -17932: pinyin = "gui " Case -17931 To -17929: pinyin = "gun "Case -17928 To -17923:-17760: pinyin = "ha "Case -17759 To -17753: pinyin = "hai "Case -17752 To -17734: pinyin = "han " Case -17733 To -17731: pinyin = "hang "Case -17730 To -17722: pinyin = "hao " Case -17721 To -17704: pinyin = "he "Case -17703 To -17702: pinyin = "hei " Case -17701 To -17698: pinyin = "hen "Case -17697 To -17693:-17684: pinyin = "hong "Case -17683 To -17677: pinyin = "hou "Case -17676 To -17497: pinyin = "hu " Case -17496 To -17488: pinyin = "hua "Case -17487 To -17483: pinyin = "huai " Case -17482 To -17469: pinyin = "huan "Case -17468 To -17455: pinyin = "huang " Case -17454 To -17434: pinyin = "hui "Case -17433 To -17428:-17418: pinyin = "huo "Case -17417 To -17203: pinyin = "ji "Case -17202 To -17186: pinyin = "jia " Case -17185 To -16984: pinyin = "jian "Case -16983 To -16971: pinyin = "jiang " Case -16970 To -16943: pinyin = "jiao "Case -16942 To -16916: pinyin = "jie " Case -16915 To -16734: pinyin = "jin "Case -16733 To -16709:-16707: pinyin = "jiong "Case -16706 To -16690: pinyin = "jiu "Case -16689 To -16665: pinyin = "ju " Case -16664 To -16658: pinyin = "juan "Case -16657 To -16648: pinyin = "jue " Case -16647 To -16475: pinyin = "jun "Case -16474 To -16471: pinyin = "ka " Case -16470 To -16466: pinyin = "kai "Case -16465 To -16460:-16453: pinyin = "kang "Case -16452 To -16449: pinyin = "kao "Case -16448 To -16434: pinyin = "ke " Case -16433 To -16430: pinyin = "ken "Case -16429 To -16428: pinyin = "keng " Case -16427 To -16424: pinyin = "kong "Case -16423 To -16420: pinyin = "kou " Case -16419 To -16413: pinyin = "ku "Case -16412 To -16408:-16404: pinyin = "kuai "Case -16403 To -16402: pinyin = "kuan "Case -16401 To -16394: pinyin = "kuang " Case -16393 To -16221: pinyin = "kui "Case -16220 To -16217: pinyin = "kun " Case -16216 To -16213: pinyin = "kuo "Case -16212 To -16206: pinyin = "la " Case -16205 To -16203: pinyin = "lai "Case -16202 To -16188:-16181: pinyin = "lang "Case -16180 To -16172: pinyin = "lao "Case -16171 To -16170: pinyin = "le " Case -16169 To -16159: pinyin = "lei "Case -16158 To -16156: pinyin = "leng " Case -16155 To -15960: pinyin = "li "Case -15959 To -15959: pinyin = "lia " Case -15958 To -15945: pinyin = "lian "Case -15944 To -15934:-15921: pinyin = "liao "Case -15920 To -15916: pinyin = "lie "Case -15915 To -15904: pinyin = "lin " Case -15903 To -15890: pinyin = "ling "Case -15889 To -15879: pinyin = "liu " Case -15878 To -15708: pinyin = "long "Case -15707 To -15702: pinyin = "lou " Case -15701 To -15682: pinyin = "lu "Case -15681 To -15668:-15662: pinyin = "luan "Case -15661 To -15660: pinyin = "lue "Case -15659 To -15653: pinyin = "lun " Case -15652 To -15641: pinyin = "luo "Case -15640 To -15632: pinyin = "ma " Case -15631 To -15626: pinyin = "mai "Case -15625 To -15455: pinyin = "man " Case -15454 To -15449: pinyin = "mang "Case -15448 To -15437:-15436: pinyin = "me "Case -15435 To -15420: pinyin = "mei "Case -15419 To -15417: pinyin = "men " Case -15416 To -15409: pinyin = "meng "Case -15408 To -15395: pinyin = "mi " Case -15394 To -15386: pinyin = "mian "Case -15385 To -15378: pinyin = "miao " Case -15377 To -15376: pinyin = "mie "Case -15375 To -15370:-15364: pinyin = "ming "Case -15363 To -15363: pinyin = "miu "Case -15362 To -15184: pinyin = "mo " Case -15183 To -15181: pinyin = "mou "Case -15180 To -15166: pinyin = "mu " Case -15165 To -15159: pinyin = "na "Case -15158 To -15154: pinyin = "nai " Case -15153 To -15151: pinyin = "nan "Case -15150 To -15150:-15145: pinyin = "nao "Case -15144 To -15144: pinyin = "ne "Case -15143 To -15142: pinyin = "nei " Case -15141 To -15141: pinyin = "nen "Case -15140 To -15140: pinyin = "neng " Case -15139 To -15129: pinyin = "ni "Case -15128 To -15122: pinyin = "nian " Case -15121 To -15120: pinyin = "niang "Case -15119 To -15118:-15111: pinyin = "nie "Case -15110 To -15110: pinyin = "nin "Case -15109 To -14942: pinyin = "ning " Case -14941 To -14938: pinyin = "niu "Case -14937 To -14934: pinyin = "nong " Case -14933 To -14931: pinyin = "nu "Case -14930 To -14930: pinyin = "nv " Case -14929 To -14929: pinyin = "nuan "Case -14928 To -14927:-14923: pinyin = "nuo "Case -14922 To -14922: pinyin = "o "Case -14921 To -14915: pinyin = "ou " Case -14914 To -14909: pinyin = "pa "Case -14908 To -14903: pinyin = "pai " Case -14902 To -14895: pinyin = "pan "Case -14894 To -14890: pinyin = "pang " Case -14889 To -14883: pinyin = "pao "Case -14882 To -14874:-14872: pinyin = "pen "Case -14871 To -14858: pinyin = "peng "Case -14857 To -14679: pinyin = "pi " Case -14678 To -14675: pinyin = "pian "Case -14674 To -14671: pinyin = "piao " Case -14670 To -14669: pinyin = "pie "Case -14668 To -14664: pinyin = "pin " Case -14663 To -14655: pinyin = "ping "Case -14654 To -14646:-14631: pinyin = "pu "Case -14630 To -14595: pinyin = "qi "Case -14594 To -14430: pinyin = "qia " Case -14429 To -14408: pinyin = "qian "Case -14407 To -14400: pinyin = "qiang " Case -14399 To -14385: pinyin = "qiao "Case -14384 To -14380: pinyin = "qie " Case -14379 To -14369: pinyin = "qin "Case -14368 To -14356:-14354: pinyin = "qiong "Case -14353 To -14346: pinyin = "qiu "Case -14345 To -14171: pinyin = "qu " Case -14170 To -14160: pinyin = "quan "Case -14159 To -14152: pinyin = "que " Case -14151 To -14150: pinyin = "qun "Case -14149 To -14146: pinyin = "ran " Case -14145 To -14141: pinyin = "rang "Case -14140 To -14138:-14136: pinyin = "re "Case -14135 To -14126: pinyin = "ren "Case -14125 To -14124: pinyin = "reng " Case -14123 To -14123: pinyin = "ri "Case -14122 To -14113: pinyin = "rong " Case -14112 To -14110: pinyin = "rou "Case -14109 To -14100: pinyin = "ru " Case -14099 To -14098: pinyin = "ruan "Case -14097 To -14095:-14093: pinyin = "run "Case -14092 To -14091: pinyin = "ruo "Case -14090 To -14088: pinyin = "sa " Case -14087 To -14084: pinyin = "sai "Case -14083 To -13918: pinyin = "san " Case -13917 To -13915: pinyin = "sang "Case -13914 To -13911: pinyin = "sao " Case -13910 To -13908: pinyin = "se "Case -13907 To -13907:-13906: pinyin = "seng "Case -13905 To -13897: pinyin = "sha "Case -13896 To -13895: pinyin = "shai " Case -13894 To -13879: pinyin = "shan "Case -13878 To -13871: pinyin = "shang " Case -13870 To -13860: pinyin = "shao "Case -13859 To -13848: pinyin = "she " Case -13847 To -13832: pinyin = "shen "Case -13831 To -13659:-13612: pinyin = "shi "Case -13611 To -13602: pinyin = "shou "Case -13601 To -13407: pinyin = "shu " Case -13406 To -13405: pinyin = "shua "Case -13404 To -13401: pinyin = "shuai " Case -13400 To -13399: pinyin = "shuan "Case -13398 To -13396: pinyin = "shuang "Case -13395 To -13392: pinyin = "shui "pinyin = "shun "Case -13387 To -13384: pinyin = "shuo "Case -13383 To -13368: pinyin = "si " Case -13367 To -13360: pinyin = "song "Case -13359 To -13357: pinyin = "sou " Case -13356 To -13344: pinyin = "su "Case -13343 To -13341: pinyin = "suan " Case -13340 To -13330: pinyin = "sui "Case -13329 To -13327: pinyin =pinyin = "suo "Case -13318 To -13148: pinyin = "ta "Case -13147 To -13139: pinyin = "tai " Case -13138 To -13121: pinyin = "tan "Case -13120 To -13108: pinyin = "tang " Case -13107 To -13097: pinyin = "tao "Case -13096 To -13096: pinyin = "te " Case -13095 To -13092: pinyin = "teng "Case -13091 To -13077: pinyin =pinyin = "tian "Case -13068 To -13064: pinyin = "tiao "Case -13063 To -13061: pinyin = "tie " Case -13060 To -12889: pinyin = "ting "Case -12888 To -12876: pinyin = "tong " Case -12875 To -12872: pinyin = "tou "Case -12871 To -12861: pinyin = "tu " Case -12860 To -12859: pinyin = "tuan "Case -12858 To -12853: pinyin =pinyin = "tun "Case -12849 To -12839: pinyin = "tuo "Case -12838 To -12832: pinyin = "wa " Case -12831 To -12830: pinyin = "wai "Case -12829 To -12813: pinyin = "wan " Case -12812 To -12803: pinyin = "wang "Case -12802 To -12608: pinyin = "wei " Case -12607 To -12598: pinyin = "wen "Case -12597 To -12595: pinyin =pinyin = "wo "Case -12585 To -12557: pinyin = "wu "Case -12556 To -12360: pinyin = "xi " Case -12359 To -12347: pinyin = "xia "Case -12346 To -12321: pinyin = "xian " Case -12320 To -12301: pinyin = "xiang "Case -12300 To -12121: pinyin = "xiao " Case -12120 To -12100: pinyin = "xie "Case -12099 To -12090: pinyin =pinyin = "xing "Case -12074 To -12068: pinyin = "xiong "Case -12067 To -12059: pinyin = "xiu " Case -12058 To -12040: pinyin = "xu "Case -12039 To -11868: pinyin = "xuan " Case -11867 To -11862: pinyin = "xue "Case -11861 To -11848: pinyin = "xun " Case -11847 To -11832: pinyin = "ya "Case -11831 To -11799: pinyin =pinyin = "yang "Case -11781 To -11605: pinyin = "yao "Case -11604 To -11590: pinyin = "ye " Case -11589 To -11537: pinyin = "yi "Case -11536 To -11359: pinyin = "yin " Case -11358 To -11341: pinyin = "ying "Case -11340 To -11340: pinyin = "yo " Case -11339 To -11325: pinyin = "yong "Case -11324 To -11304: pinyin =pinyin = "yu "Case -11097 To -11078: pinyin = "yuan "Case -11077 To -11068: pinyin = "yue " Case -11067 To -11056: pinyin = "yun "Case -11055 To -11053: pinyin = "za " Case -11052 To -11046: pinyin = "zai "Case -11045 To -11042: pinyin = "zan " Case -11041 To -11039: pinyin = "zang "Case -11038 To -11025: pinyin =pinyin = "ze "Case -11020 To -11020: pinyin = "zei "Case -11019 To -11019: pinyin = "zen " Case -11018 To -11015: pinyin = "zeng "Case -11014 To -10839: pinyin = "zha " Case -10838 To -10833: pinyin = "zhai "Case -10832 To -10816: pinyin = "zhan " Case -10815 To -10801: pinyin = "zhang "Case -10800 To -10791: pinyin =pinyin = "zhe "Case -10780 To -10765: pinyin = "zhen "Case -10764 To -10588: pinyin = "zheng " Case -10587 To -10545: pinyin = "zhi "Case -10544 To -10534: pinyin = "zhong " Case -10533 To -10520: pinyin = "zhou "Case -10519 To -10332: pinyin = "zhu " Case -10331 To -10330: pinyin = "zhua "Case -10329 To -10329: pinyin =pinyin = "zhuan "Case -10322 To -10316: pinyin = "zhuang "Case -10315 To -10310: pinyin = "zhui " Case -10309 To -10308: pinyin = "zhun "Case -10307 To -10297: pinyin = "zhuo " Case -10296 To -10282: pinyin = "zi "Case -10281 To -10275: pinyin = "zong " Case -10274 To -10271: pinyin = "zou "Case -10270 To -10263:-10261: pinyin = "zuan "Case -10260 To -10257: pinyin = "zui "Case -10256 To -10255: pinyin = "zun " Case -10254 To -10254: pinyin = "zuo "Case Else: pinyin = pEnd Select End FunctionFunction getpy(st r) '得到拼音For i = 1 ToLen(str)getpy = getpy & pinyin(M id(str, i, 1)) Next iEnd FunctionFunction gets(str ) '得到首字母gets = Left(get py(str), 1)End Function Function getqs(st r) '得到全首字母For i = 1 ToLen(str)getqs = getqs & Left(pin yin(Mid( str, i, 1)), 1) Next iEnd Function按“ Alt+F11 ”组合键，进入Visual Basic编辑状态，执行 “插入→模块 ”命令，到模块编辑块中，保存。
用VBA实现Excel电子表格汉字与拼音的转换
２ 汉字一 拼 音转 换原 理
以Ｇ Ｂ １ ８ ０ ３ ０规 范 Ｂ Ｏ Ａｌ ～ Ｆ Ｔ Ｆ Ｅ编 码 范 ¨ ； ｌ 内的 ６ ７ ６ ３个 汉 字 为 例 ， 介绍 Ｅ ｘ ｃ ｅ ｌ 表格 Ｉ ｆ １ 利川 Ｖ Ｂ Ａ代 码 实 现 汉 宇 转 换 为 拼音 的 办 法 ，这 些 汉 字 覆 盖 了 中 罔大 陆 汉 ９ ９ ． ７ ５ ％的使
字 与拼 音 的 转 换 函 数 ， 不 能 直 接 将 表 格 中 的 ’ ７ 义 字 转 换 为拼
拼 音字 母顺序排 列 ，同音字 以笔形 顺序 横 、ｒ ｆ 、撇 、点 、
折为序 ；第二级汉字 ３ ０ ０ ８个 ，置于 ５ ６
８ ７ ．按 首鄙
排列 ，间Ｉ 田 ｉ 数的字 也以笔形顺 序为序 ． 对 仃意 一个 肜字 符部采 川两个宁节表 示 ，『 ｊ 仃 向的字节 为笫 一字节 ，后面的
ＨＺ
一
载宏命 令才能正常使川 的雨数 ．自定义函数是通过 Ｖ Ｂ Ａ代
码 实现特定功能 的函数。Ｅ ｘ ｃ ｅ ｌ 自定 义 数 南用 户 自己 编 写 开 发 ，一个 白定 义 函 数 就 是一 个 Ｆ ｕ ｎ ｃ ｔ ｉ ｏ ｎ过 程 在 Ｅ ｘ ｃ ｅ ｌ 巾 用 Ｖ Ｂ Ａ代 码 创 建 自定 义 蛹数 具 有 如 下 优 点 ：
音： 企业人员较 少时 还可 以用 键盘 手动输 入拼 音 ，但 人数 成 盯上 下时 ，采川 手动输入 的方法就极 大地 降低 丁 １
作 效 率 利用 Ｖ Ｂ Ａ对 Ｅ ｘ ｃ ｅ ｌ 进 行 二次 开 发 ． 可 有 效 地 白定 义干 ¨ 扩展 Ｅ ｘ ｃ ｅ ｌ 的功 能 ，例 如 ：可将 Ｅ ｘ ｃ ｅ ｌ 电子 表格 中 的汉 字转 换 为 拼 音 。 首 先采 用 Ｖ Ｂ Ａ编 程 定 义 了汉 语 一 拼 音 转换 函数 ，然 后 涮刚 该 自定 义 的转换 函数 ，实现 ＿ ｒ 汉字一 拼 音 的快速 转 换 。
3500个常用汉字带拼音
3500个常用汉字啊(ā)阿(ā)埃(āi)挨(āi)哎(āi)唉(āi)哀(āi)皑(ái) 癌(ái) 蔼(ǎi)矮(ǎi)艾(ài) 碍(ài) 爱(ài) 隘(ài) 鞍(ān)氨(ān)安(ān)俺(ǎn)按(àn) 暗(àn) 岸(àn) 胺(àn) 案(àn) 肮(ānɡ)昂(ánɡ)盎(ànɡ)凹(āo)敖(áo) 熬(áo) 翱(áo) 袄(ǎo)傲(ào) 奥(ào) 懊(ào) 澳(ào)芭(bā)捌(bā)扒(bā)叭(bā)吧(bɑ)笆(bā)八(bā)疤(bā)巴(bā)拔(bá) 跋(bá) 靶(bǎ)把(bǎ)耙(pá) 坝(bà) 霸(bà) 罢(bà) 爸(bà) 白(bái) 柏(bǎi)百(bǎi)摆(bǎi)佰(bǎi)败(bài) 拜(bài) 稗(bài) 斑(bān)班(bān)搬(bān)扳(bān)般(bān)颁(bān)板(bǎn)版(bǎn)扮(bàn) 拌(bàn) 伴(bàn) 瓣(bàn) 半(bàn) 办(bàn) 绊(bàn) 邦(bānɡ)帮(bānɡ) 梆(bānɡ)榜(bǎnɡ)膀(bǎnɡ)绑(bǎnɡ)棒(bànɡ)磅(bànɡ)蚌(bànɡ)镑(bànɡ)傍(bànɡ)谤(bànɡ)苞(bāo)胞(bāo)包(bāo)褒(bāo)剥(bāo)薄(báo) 雹(báo) 保(bǎo)堡(bǎo)饱(bǎo)宝(bǎo)抱(bào) 报(bào) 暴(bào) 豹(bào) 鲍(bào) 爆(bào) 杯(bēi)碑(bēi)悲(bēi)卑(bēi)北(běi)辈(bèi) 背(bèi) 贝(bèi) 钡(bèi) 倍(bèi) 狈(bèi) 备(bèi) 惫(bèi) 焙(bèi) 被(bèi) 奔(bēn)苯(běn)本(běn)笨(bèn) 崩(bēnɡ)绷(bēnɡ)甭(bénɡ)泵(bènɡ)蹦(bènɡ)迸(bènɡ)逼(bī)鼻(bí) 比(bǐ)鄙(bǐ)笔(bǐ)彼(bǐ)碧(bì) 蓖(bì) 蔽(bì) 毕(bì) 毙(bì) 毖(bì) 币(bì) 庇(bì) 痹(bì) 闭(bì) 敝(bì) 弊(bì) 必(bì) 辟(pì) 壁(bì) 臂(bì) 避(bì) 陛(bì) 鞭(biān)边(biān)编(biān)贬(biǎn)扁(biǎn)便(biàn) 变(biàn) 卞(biàn) 辨(biàn) 辩(biàn) 辫(biàn) 遍(biàn) 标(biāo)彪(biāo)膘(biāo)表(biǎo)鳖(biē)憋(biē)别(bié) 瘪(biě)彬(bīn)斌(bīn)濒(bīn)滨(bīn)宾(bīn)摈(bìn) 兵(bīnɡ)冰(bīnɡ)柄(bǐnɡ)丙(bǐnɡ)秉(bǐnɡ)饼(bǐnɡ)炳(bǐnɡ)病(bìnɡ)并(bìnɡ)玻(bō)菠(bō)播(bō)拨(bō)钵(bō)波(bō)博(bó) 勃(bó) 搏(bó) 铂(bó) 箔(bó) 伯(bó) 帛(bó) 舶(bó) 脖(bó) 膊(bó) 渤(bó) 泊(bó) 驳(bó) 捕(bǔ)卜(bǔ)哺(bǔ)补(bǔ)埠(bù) 不(bú) 布(bù) 步(bù) 簿(bù) 部(bù) 怖(bù)擦(cā)猜(cāi)裁(cái) 材(cái) 才(cái) 财(cái) 睬(cǎi) 踩(cǎi)采(cǎi)彩(cǎi)菜(cài) 蔡(cài) 餐(cān)参(cān)蚕(cán) 残(cán) 惭(cán) 惨(cǎn)灿(càn) 苍(cānɡ)舱(cānɡ)仓(cānɡ)沧(cānɡ)藏(cánɡ)操(cāo)糙(cāo)槽(cáo) 曹(cáo) 草(cǎo)厕(cè) 策(cè) 侧(cè) 册(cè) 测(cè) 层(cénɡ)蹭(cènɡ)插(chā)叉(chā)茬(chá) 茶(chá) 查(chá) 碴(chá) 搽(chá) 察(chá) 岔(chà) 差(chà) 诧(chà) 拆(chāi)柴(chái) 豺(chái) 搀(chān)掺(chān)蝉(chán) 馋(chán) 谗(chán) 缠(chán) 铲(chǎn)产(chǎn)阐(chǎn)颤(chàn) 昌(chānɡ)猖(chānɡ)场(chǎnɡ)尝(chánɡ)常(chánɡ)长(chánɡ)偿(chánɡ)肠(chánɡ)厂(chǎnɡ)敞(chǎnɡ)畅(chànɡ)唱(chànɡ)倡(chànɡ)超(chāo) 抄(chāo)钞(chāo)朝(cháo) 嘲(cháo) 潮(cháo) 巢(cháo) 吵(chǎo)炒(chǎo)车(chē)扯(chě)撤(chè) 掣(chè) 彻(chè) 澈(chè) 郴(chēn)臣(chén) 辰(chén) 尘(chén) 晨(chén) 忱(chén) 沉(chén) 陈(chén) 趁(chèn) 衬(chèn) 撑(chēnɡ)称(chēnɡ)城(chénɡ)橙(chénɡ)成(chénɡ)呈(chénɡ)乘(chénɡ)程(chénɡ)惩(chénɡ)澄(chénɡ)诚(chénɡ)承(chénɡ)逞(chěnɡ)骋(chěnɡ)秤(chènɡ)吃(chī)痴(chī)持(chí) 匙(shi) 池(chí) 迟(chí) 弛(chí) 驰(chí) 耻(chǐ)齿(chǐ)侈(chǐ)尺(chǐ)赤(chì) 翅(chì) 斥(chì) 炽(chì) 充(chōnɡ)冲(chōnɡ)虫(chónɡ)崇(chónɡ)宠(chǒnɡ)抽(chōu)酬(chóu) 畴(chóu) 踌(chóu) 稠(chóu) 愁(chóu) 筹(chóu) 仇(chóu) 绸(chóu) 瞅(chǒu)丑(chǒu)臭(chòu) 初(chū)出(chū)橱(chú) 厨(chú) 躇(chú) 锄(chú) 雏(chú) 滁(chú) 除(chú) 楚(chǔ)础(chǔ)储(chǔ)矗(chù) 搐(chù) 触(chù) 处(chù) 揣(chuāi)川(chuān)穿(chuān)椽(chuán) 传(chuán) 船(chuán) 喘(chuǎn)串(chuàn) 疮(chuānɡ) 窗(chuānɡ)幢(zhuànɡ)床(chuánɡ)闯(chuǎnɡ)创(chuànɡ)吹(chuī)炊(chuī)捶(chuí) 锤(chuí) 垂(chuí) 春(chūn)椿(chūn)醇(chún) 唇(chún) 淳(chún) 纯(chún) 蠢(chǔn)戳(chuō)绰(chāo)疵(cī)茨(cí) 磁(cí) 雌(cí) 辞(cí) 慈(cí) 瓷(cí) 词(cí) 此(cǐ)刺(cì) 赐(cì) 次(cì) 聪(cōnɡ)葱(cōnɡ)囱(cōnɡ)匆(cōnɡ)从(cónɡ)丛(cónɡ)凑(còu) 粗(cū)醋(cù) 簇(cù) 促(cù) 蹿(cuān)篡(cuàn) 窜(cuàn) 摧(cuī)崔(cuī)催(cuī)脆(cuì) 瘁(cuì) 粹(cuì) 淬(cuì)翠(cuì)村(cūn)存(cún) 寸(cùn) 磋(cuō)撮(cuō)搓(cuō)措(cuò) 挫(cuò) 错(cuò)搭(dā)达(dá) 答(dá) 瘩(dá) 打(dǎ)大(dà) 呆(dāi)歹(dǎi)傣(dǎi)戴(dài) 带(dài) 殆(dài) 代(dài) 贷(dài) 袋(dài) 待(dài) 逮(dǎi)怠(dài) 耽(dān)担(dān)丹(dān)单(dān)郸(dān)掸(dǎn)胆(dǎn)旦(dàn) 氮(dàn) 但(dàn) 惮(dàn) 淡(dàn) 诞(dàn) 弹(dàn) 蛋(dàn) 当(dānɡ)挡(dǎnɡ)党(dǎnɡ)荡(dànɡ)档(dànɡ)刀(dāo)捣(dǎo)蹈(dǎo)倒(dǎo)岛(dǎo)祷(dǎo)导(dǎo)到(dào) 稻(dào) 悼(dào) 道(dào) 盗(dào) 德(dé) 得(dé) 的(de) 蹬(dēnɡ)灯(dēnɡ)登(dēnɡ)等(děnɡ)瞪(dènɡ)凳(dènɡ)邓(dènɡ)堤(dī)低(dī)滴(dī)迪(dí) 敌(dí) 笛(dí) 狄(dí) 涤(dí) 翟(zhái) 嫡(dí) 抵(dǐ)底(dǐ)地(dì) 蒂(dì) 第(dì) 帝(dì) 弟(dì) 递(dì) 缔(dì) 颠(diān)掂(diān)滇(diān)碘(diǎn)点(diǎn)典(diǎn)靛(diàn) 垫(diàn) 电(diàn) 佃(diàn) 甸(diàn) 店(diàn) 惦(diàn) 奠(diàn) 淀(diàn) 殿(diàn) 碉(diāo)叼(diāo)雕(diāo)凋(diāo)刁(diāo)掉(diào) 吊(diào) 钓(diào) 调(diào) 跌(diē)爹(diē)碟(dié) 蝶(dié) 迭(dié) 谍(dié) 叠(dié) 丁(dīnɡ)盯(dīnɡ)叮(dīnɡ)钉(dìnɡ)顶(dǐnɡ)鼎(dǐnɡ)锭(dìnɡ)定(dìnɡ)订(dìnɡ)丢(diū)东(dōnɡ)冬(dōnɡ)董(dǒnɡ)懂(dǒnɡ)动(dònɡ)栋(dònɡ)侗(dònɡ)恫(dònɡ)冻(dònɡ)洞(dònɡ)兜(dōu)抖(dǒu)斗(dòu) 陡(dǒu)豆(dòu) 逗(dòu) 痘(dòu) 都(dōu)督(dū)毒(dú) 犊(dú) 独(dú) 读(dú) 堵(dǔ)睹(dǔ)赌(dǔ)杜(dù) 镀(dù) 肚(dù) 度(dù) 渡(dù) 妒(dù) 端(duān)短(duǎn)锻(duàn) 段(duàn) 断(duàn) 缎(duàn) 堆(duī)兑(duì) 队(duì) 对(duì) 墩(dūn)吨(dūn)蹲(dūn)敦(dūn)顿(dùn) 囤(dùn) 钝(dùn) 盾(dùn) 遁(dùn) 掇(duō)哆(duō)多(duō)夺(duó) 垛(duǒ)躲(duǒ)朵(duǒ)跺(duò) 舵(duò) 剁(duò) 惰(duò) 堕(duò)蛾(é) 峨(é) 鹅(é) 俄(é) 额(é) 讹(é) 娥(é) 恶(è) 厄(è) 扼(è) 遏(è) 鄂(è) 饿(è) 恩(ēn)而(ér) 儿(ér) 耳(ěr)尔(ěr)饵(ěr)洱(ěr)二(èr) 贰(èr)发(fā)罚(fá) 筏(fá) 伐(fá) 乏(fá) 阀(fá) 法(fǎ)珐(fà) 藩(fān)帆(fān)番(fān)翻(fān)樊(fán) 矾(fán) 钒(fán) 繁(fán) 凡(fán) 烦(fán) 反(fǎn)返(fǎn)范(fàn) 贩(fàn) 犯(fàn) 饭(fàn) 泛(fàn) 坊(fānɡ)芳(fānɡ)方(fānɡ)肪(fánɡ)房(fánɡ)防(fánɡ)妨(fánɡ)仿(fǎnɡ)访(fǎnɡ)纺(fǎnɡ)放(fànɡ)菲(fēi)非(fēi)啡(fēi)飞(fēi)肥(féi) 匪(fěi)诽(fěi)吠(fèi) 肺(fèi) 废(fèi) 沸(fèi) 费(fèi) 芬(fēn)酚(fēn)吩(fēn)氛(fēn)分(fēn)纷(fēn)坟(fén) 焚(fén) 汾(fén) 粉(fěn)奋(fèn) 份(fèn) 忿(fèn) 愤(fèn) 粪(fèn) 丰(fēnɡ)封(fēnɡ)枫(fēnɡ)蜂(fēnɡ)峰(fēnɡ)锋(fēnɡ)风(fēnɡ)疯(fēnɡ)烽(fēnɡ)逢(fénɡ)冯(fénɡ)缝(fénɡ)讽(fěnɡ)奉(fènɡ)凤(fènɡ)佛(fó) 否(fǒu)夫(fū)敷(fū)肤(fū)孵(fū)扶(fú) 拂(fú) 辐(fú) 幅(fú) 氟(fú) 符(fú) 伏(fú) 俘(fú) 服(fú) 浮(fú) 涪(fú) 福(fú) 袱(fú) 弗(fú) 甫(fǔ)抚(fǔ)辅(fǔ)俯(fǔ)釜(fǔ)斧(fǔ)脯(pú) 腑(fǔ)府(fǔ)腐(fǔ)赴(fù) 副(fù) 覆(fù) 赋(fù) 复(fù) 傅(fù) 付(fù) 阜(fù) 父(fù) 腹(fù) 负(fù) 富(fù) 讣(fù) 附(fù) 妇(fù) 缚(fù) 咐(fù)噶(ɡá)嘎(ɡā)该(ɡāi)改(ɡǎi)概(ɡài)钙(ài) 盖(ɡài)溉(ɡài)干(ɡàn)甘(ɡān)杆(ɡǎn)柑(ɡān)竿(ɡān)肝(ɡān)赶(ɡǎn)感(ɡǎn)秆(ɡǎn)敢(ɡǎn)赣(ɡàn)肛(ɡānɡ)纲(ɡānɡ)岗(ɡǎnɡ)港(ɡǎnɡ)杠(ɡànɡ)篙(ɡāo)皋(ɡāo)高(ɡāo)膏(ɡāo)羔(ɡāo)糕(ɡāo)搞(ɡǎo)镐(ɡǎo)稿(ɡǎo)告(ɡào)哥(ɡē)歌(ɡē)搁(ɡē)戈(ɡē)鸽(ɡē)胳(ɡē)疙(ɡē)割(ɡē)革(ɡé)葛(ɡě)格(ɡé)蛤(há) 阁(ɡé)隔(ɡé)铬(ɡè)个(ɡè)各(ɡè)给(ɡěi)根(ɡēn)跟(ɡēn)耕(ɡēnɡ)更(ɡènɡ)庚(ɡēnɡ)羹(ɡēnɡ)埂(ɡěnɡ)耿(ɡěnɡ)梗(ɡěnɡ)工(ɡōnɡ)攻(ɡōnɡ)功(ɡōnɡ)恭(ɡōnɡ)龚(ɡōnɡ)供(ɡònɡ)躬(ɡōnɡ)公(ɡōnɡ)宫(ɡōnɡ)弓(ɡōnɡ)巩(ɡǒnɡ)汞(ɡǒnɡ)拱(ɡǒnɡ)贡(ɡòn)共(ɡònɡ)钩(ɡōu)勾(ɡōu)沟(ɡōu)苟(ɡǒu)狗(ɡǒu)垢(ɡòu)构(ɡòu)购(ɡòu)够(ɡòu)辜(ɡū)菇(ɡū)咕(ɡū)箍(ɡū)估(ɡū)沽(ɡū)孤(ɡū)姑(ɡū)鼓(ɡǔ)古(ɡǔ)蛊(ɡǔ)骨(ɡǔ)谷(ɡǔ)股(ɡǔ)故(ɡù)顾(ɡù)固(ɡù)雇(ɡù)刮(ɡuā)瓜(ɡuā)剐(ɡuǎ)寡(ɡuǎ)挂(ɡuà)褂(ɡuà)乖(ɡuāi)拐(ɡuǎi)怪(ɡuài)棺(ɡuān)关(ɡuān)官(ɡuān)冠(ɡuàn)观(ɡuān)管(ɡuǎn)馆(ɡuǎn)罐(ɡuàn)惯(ɡuàn)灌(ɡuàn)贯(ɡɡuàn)光(ɡuānɡ)广(ɡuǎnɡ)逛(ɡuànɡ)瑰(ɡuī)规(ɡuī)圭(ɡuī)硅(ɡuī)归(ɡuī)龟(ɡuī)闺(ɡɡuī)轨(ɡuǐ)鬼(ɡuǐ)诡(ɡuǐ)癸(ɡuǐ)桂(ɡuì)柜(ɡuì)跪(ɡuì)贵(ɡuì)刽(ɡuì)辊(ɡǔn)滚(ɡǔn)棍(ɡùn)锅(ɡuō)郭(ɡuō)国(ɡuó)果(ɡuǒ)裹(ɡuǒ)过(ɡuò)哈(hā)骸(hái) 孩(hái) 海(hǎi)氦(hài) 亥(hài) 害(hài) 骇(hài) 酣(hān)憨(hān)邯(hán) 韩(hán) 含(hán) 涵(hán) 寒(hán) 函(hán) 喊(hǎn)罕(hǎn)翰(hàn) 撼(hàn) 扞(hàn) 旱(hàn) 憾(hàn) 悍(hàn) 焊(hàn) 汗(hàn) 汉(hàn）夯(hānɡ)杭(hánɡ)航(hánɡ)壕(háo) 嚎(háo) 豪(háo) 毫(háo) 郝(hǎo)好(hǎo)耗(hào) 号(hào) 浩(hào) 呵(hē)喝(hē)荷(hé)菏(hé) 核(hé) 禾(hé) 和(hé) 何(hé) 合(hé) 盒(hé) 貉(hé) 阂(hé) 河(hé) 涸(hé) 赫(hè) 褐(hè) 鹤(hè) 贺(hè) 嘿(hēi)黑(hēi)痕(hén) 很(hěn)狠(hěn)恨(hèn) 哼(hēnɡ)亨(hēnɡ)横(hénɡ)衡(hénɡ)恒(hénɡ)轰(hōnɡ)哄(hǒnɡ)烘(hōnɡ)虹(hónɡ)鸿(hónɡ)洪(hónɡ)宏(hónɡ)弘(hónɡ)红(hónɡ)喉(hóu) 侯(hóu) 猴(hóu) 吼(hǒu)厚(hòu) 候(hòu) 后(hòu) 呼(hū)乎(hū)忽(hū)瑚(hú) 壶(hú) 葫(hú) 胡(hú) 蝴(hú) 狐(hú) 糊(hú) 湖(hú) 弧(hú) 虎(hǔ)唬(hǔ)护(hù) 互(hù) 沪(hù) 户(hù) 花(huā)哗(huá) 华(huá) 猾(huá) 滑(huá) 画(huà) 划(huá) 化(huà) 话(huà) 槐(huái) 徊(huái) 怀(huái) 淮(huái) 坏(huài) 欢(huān)环(huán) 桓(huán) 还(hái) 缓(huǎn)换(huàn)患(huàn灰(huī)挥(huī)辉(huī)徽(huī)恢(huī)蛔(huí) 回(huí) 毁(huǐ)悔(huǐ)慧(huì) 卉(huì) 惠(huì) 晦(huì) 贿(huì) 秽(huì) 会(huì) 烩(huì) 汇(huì) 讳(huì) 诲(huì) 绘(huì) 荤(hūn)昏(hūn)婚(hūn)魂(hún) 浑(hún) 混(hún) 豁(huō)活(huó) 伙(huǒ)火(huǒ)获(huò) 或(huò) 惑(huò) 霍(huò) 货(huò) 祸(huò)击(jī)圾(jī)基(jī)机(jī)畸(jī)稽(jī)积(jī)箕(jī)肌(jī)饥(jī)迹(jì) 激(jī)讥(jī)鸡(jī)姬(jī)绩(jì) 缉(jī)吉(jí) 极(jí) 棘(jí) 辑(jí) 籍(jí) 集(jí) 及(jí) 急(jí) 疾(jí) 汲(jí) 即(jí) 嫉(jí) 级(jí) 挤(jǐ)几(jǐ)脊(jǐ)己(jǐ)蓟(jì) 技(jì) 冀(jì) 季(jì) 伎(jì) 祭(jì) 剂(jì) 悸(jì) 济(jì) 寄(jì) 寂(jì) 计(jì) 记(jì) 既(jì) 忌(jì) 际(jì) 妓(jì) 继(jì) 纪(jì) 嘉(jiā)枷(jiā)夹(jiá) 佳(jiā)家(jiā)加(jiā)荚(jiá) 颊(jiá) 贾(jiǎ)甲(jiǎ)钾(jiǎ)假(jiǎ)稼(jià) 价(jià) 架(jià) 驾(jià) 嫁(jià) 歼(jiān)监(jiān)坚(jiān)尖(jiān)笺(jiān)间(jiān)煎(jiān) 兼(jiān)肩(jiān)艰(jiān)奸(jiān)缄(jiān)茧(jiǎn)检(jiǎn)柬(jiǎn)碱(jiǎn)碱(jiǎn)拣(jiǎn)捡(jiǎn)简(jiǎn)俭(jiǎn)剪(jiǎn)减(jiǎn)荐(jiàn) 槛(kǎn)鉴(jiàn) 践(jiàn) 贱(jiàn) 见(jiàn) 键(jiàn) 箭(jiàn) 件(jiàn) 健(jiàn) 舰(jiàn) 剑(jiàn) 饯(jiàn) 渐(jiàn) 溅(jiàn) 涧(jiàn) 建(jiàn) 僵(jiānɡ)姜(jiānɡ)将(jiānɡ)浆(jiānɡ)江(jiānɡ)疆(jiānɡ)蒋(jiǎnɡ)桨(jiǎnɡ)奖(jiǎnɡ)讲(jiǎnɡ)匠(jiànɡ)酱(jiànɡ)降(jiànɡ)蕉(jiāo)椒(jiāo)礁(jiāo)焦(jiāo)胶(jiāo)交(jiāo)郊(jiāo)浇(jiāo)骄(jiāo)娇(jiāo)嚼(jiáo) 搅(jiǎo)铰(jiǎo)矫(jiǎo)侥(yáo) 脚(jiǎo)狡(j iǎo)角(jiǎo)饺(jiǎo)缴(jiǎo)绞(jiǎo)剿(jiǎo)教(jiāo)酵(jiào) 轿(jiào) 较(jiào) 叫(jiào) 窖(jiào) 揭(jiē)接(jiē)皆(jiē)秸(jiē)街(jiē)阶(jiē)截(jié) 劫(jié) 节(jiē)桔(jié) 杰(jié) 捷(jié) 睫(jié) 竭(jié) 洁(jié) 结(jié) 解(jiě)姐(jiě)戒(jiè) 藉(jiè) 芥(jiè) 界(jiè) 借(jiè) 介(jiè) 疥(jiè) 诫(jiè) 届(jiè) 巾(jīn)筋(jīn)斤(jīn)金(jīn)今(jīn)津(jīn)襟(jīn)紧(jǐn)锦(jǐn)仅(jǐn)谨(jǐn)进(jìn) 靳(jìn) 晋(jìn) 禁(jìn) 近(jìn) 烬(jìn) 浸(jìn) 尽(jìn) 劲(jìn) 荆(jīnɡ)兢(jīnɡ)茎(jīnɡ)睛(jīnɡ)晶(jīnɡ)鲸(jīnɡ)京(jīnɡ)惊(jīnɡ)精(jīnɡ)粳(jīnɡ)经(jīnɡ)井(jǐnɡ)警(jǐnɡ)景(jǐnɡ)颈(jǐnɡ)静(jìnɡ)境(jìnɡ)敬(jìnɡ)镜(jìnɡ)径(jìnɡ)痉(jìnɡ)靖(jìnɡ)竟(jìnɡ)竞(jìnɡ)净(jìnɡ)炯(jiǒnɡ)窘(jiǒnɡ)揪(jiū)究(jiū)纠(jiū)玖(jiǔ)韭(jiǔ)久(jiǔ)灸(jiǔ)九(jiǔ)酒(jiǔ)厩(jiù) 救(jiù) 旧(jiù) 臼(jiù) 舅(jiù) 咎(jiù) 就(jiù) 疚(jiù) 鞠(jū)拘(jū)狙(jū)疽(jū)居(jū)驹(jū)菊(jú) 局(jú) 咀(jǔ)矩(jǔ)举(jǔ)沮(jǔ)聚(jù) 拒(jù) 据(jù) 巨(jù) 具(jù) 距(jù) 踞(jù) 锯(jù) 俱(jù) 句(jù) 惧(jù) 炬(jù) 剧(jù) 捐(juān)鹃(juān)娟(juān)倦(juàn) 眷(juàn) 卷(juǎn)绢(juàn) 撅(juē)攫(jué) 抉(jué) 掘(jué) 倔(juè) 爵(jué) 觉(jiào) 决(jué) 诀(jué) 绝(jué) 均(jūn)菌(jūn)钧(jūn)军(jūn)君(jūn)峻(jùn) 俊(jùn) 竣(jùn) 浚(xùn) 郡(jùn) 骏(jùn)喀(kā)咖(kā)卡(kǎ)咯(ɡē)开(kāi)揩(kāi)楷(kǎi)凯(kǎi)慨(kǎi)刊(kān)堪(kān)勘(kān)坎(kǎn)砍(kǎn)看(kàn) 康(kānɡ)慷(kānɡ)糠(kānɡ)扛(kánɡ)抗(kànɡ)亢(kànɡ)炕(kànɡ)考(kǎo)拷(kǎo)烤(kǎo)靠(kào) 坷(kě)苛(kē)柯(kē)棵(kē)磕(kē)颗(kē)科(kē)壳(ké) 咳(hāi)可(kě)渴(kě)克(kè) 刻(kè) 客(kè) 课(kè) 肯(kěn)啃(kěn)垦(kěn)恳(kěn)坑(kēnɡ)吭(kēnɡ)空(kōnɡ)恐(kǒnɡ)孔(kǒnɡ)控(kònɡ)抠(kōu)口(kǒu)扣(kòu) 寇(kòu) 枯(kū)哭(kū)窟(kū)苦(kǔ)酷(kù) 库(kù) 裤(kù) 夸(kuā)垮(kuǎ)挎(kuà) 跨(kuà) 胯(kuà) 块(kuài) 筷(kuài) 侩(kuài) 快(kuài) 宽(kuān)款(kuǎn)匡(kuānɡ)筐(kuānɡ)狂(kuánɡ)框(kuànɡ)矿(kuànɡ)眶(kuànɡ)旷(kuànɡ)况(kuànɡ)亏(kuī)盔(kuī)岿(kuī)窥(kuī)葵(kuí) 奎(kuí) 魁(kuí) 傀(ɡuī)馈(kuì) 愧(kuì) 溃(kuì) 坤(kūn)昆(kūn)捆(kǔn)困(kùn) 括(kuò) 扩(kuò) 廓(kuò) 阔(kuò)垃(lā)拉(lā)喇(lā)蜡(là) 腊(là) 辣(là) 啦(lā)莱(lái) 来(lái) 赖(lài) 蓝(lán) 婪(lán) 栏(lán) 拦(lán) 篮(lán) 阑(lán) 兰(lán) 澜(lán) 谰(lán) 揽(lǎn)览(lǎn)懒(lǎn)缆(lǎn)烂(làn) 滥(làn) 琅(lánɡ)榔(lánɡ)狼(lánɡ)廊(lánɡ)郎(lánɡ)朗(lǎnɡ)浪(lànɡ)捞(lāo)劳(láo) 牢(láo) 老(lǎo)佬(lǎo)姥(lǎo)酪(lào) 烙(lào) 涝(láo) 勒(lè) 乐(lè) 雷(léi) 镭(léi) 蕾(lěi)磊(lěi)累(lèi) 儡(lěi)垒(lěi)擂(lèi) 肋(lèi) 类(lèi) 泪(lèi) 棱(lénɡ)楞(lénɡ)冷(lěnɡ)厘(lí) 梨(lí) 犁(lí) 黎(lí) 篱(lí) 狸(lí) 离(lí) 漓(lí) 理(lǐ)李(lǐ)里(lǐ)鲤(lǐ)礼(lǐ)莉(lì) 荔(lì) 吏(lì) 栗(lì) 丽(lì) 厉(lì) 励(lì) 砾(lì) 历(lì) 利(lì) 僳(sù) 例(lì) 俐(lì) 痢(lì) 立(lì) 粒(lì) 沥(lì) 隶(lì) 力(lì) 璃(lí) 哩(lǐ)俩(liǎnɡ)联(lián) 莲(lián) 连(lián) 镰(lián) 廉(lián) 怜(lián) 涟(lián) 帘(lián) 敛(liǎn)脸(liǎn)链(liàn) 恋(liàn) 炼(liàn) 练(liàn) 粮(liánɡ)凉(liánɡ)梁(liánɡ)粱(liánɡ)良(liánɡ)两(liǎnɡ)辆(liànɡ)量(liànɡ)晾(liànɡ)亮(liànɡ)谅(liànɡ)撩(liáo) 聊(liáo) 僚(liáo) 疗(liáo) 燎(liáo) 寥(liáo) 辽(liáo) 潦(liáo) 了(le) 撂(liào) 镣(liào) 廖(liào) 料(liào) 列(liè) 裂(liè) 烈(liè) 劣(liè) 猎(liè) 琳(lín) 林(lín) 磷(lín) 霖(lín) 临(lín) 邻(lín) 鳞(lín) 淋(lín) 凛(lǐn)赁(lìn) 吝(lìn) 拎(līn)玲(línɡ)菱(línɡ)零(línɡ)龄(línɡ)铃(línɡ)伶(línɡ)羚(línɡ)凌(línɡ)灵(línɡ)陵(línɡ)岭(lǐnɡ)领(lǐnɡ)另(lìnɡ)令(lìnɡ)溜(liū)琉(liú) 榴(liú) 硫(liú) 馏(liú) 留(liú) 刘(liú) 瘤(liú) 流(liú) 柳(liǔ)六(liù) 龙(lónɡ)聋(lónɡ)咙(lónɡ)笼(lónɡ)窿(lónɡ)隆(lónɡ)垄(lǒnɡ)拢(lǒnɡ)陇(lǒnɡ)楼(lóu) 娄(lóu) 搂(lǒu)篓(lǒu)漏(lòu) 陋(lòu) 芦(lú) 卢(lú) 颅(lú) 庐(lú) 炉(lú) 掳(lǔ)卤(lǔ)虏(lǔ)鲁(lǔ)麓(lù) 碌(lù) 露(lù) 路(lù) 赂(lù) 鹿(lù) 潞(lù) 禄(lù) 录(lù) 陆(lù) 戮(lù) 驴(lǘ)吕(lǚ)铝(lǚ)侣(lǚ)旅(lǚ)履(lǚ)屡(lǚ)缕(lǚ)虑(lǜ)氯(lǜ)律(lǜ)率(lǜ)滤(lǜ)绿(lǜ)峦(luán) 挛(luán) 孪(luán) 滦(luán) 卵(luǎn)乱(luàn) 掠(luě)略(luè) 抡(lūn)轮(lún) 伦(lún) 仑(lún) 沦(lún) 纶(lún) 论(lùn) 萝(luó) 螺(luó) 罗(luó) 逻(luó) 锣(luó) 箩(luó) 骡(luó) 裸(luǒ)落(luò) 洛(luò) 骆(jià) 络(luò)妈(mā)麻(má) 玛(mǎ)码(mǎ)蚂(mǎ)马(mǎ)骂(mà) 嘛(mɑ)吗(mɑ)埋(mái) 买(mǎi)麦(mài) 卖(mài) 迈(mài) 脉(mài) 瞒(mán) 馒(mán) 蛮(mán) 满(mǎn)蔓(màn) 曼(màn) 慢(màn) 漫(màn) 谩(màn) 芒(mánɡ)茫(mánɡ)盲(mánɡ)氓(mánɡ)忙(mánɡ)莽(mǎnɡ)猫(māo)茅(máo) 锚(máo) 毛(máo) 矛(máo) 铆(mǎo)卯(mǎo)茂(mào) 冒(mào) 帽(mào) 貌(mào) 贸(mào) 么(me) 玫(méi) 枚(méi) 梅(méi) 酶(méi) 霉(méi) 煤(méi) 没(méi) 眉(méi) 媒(méi) 镁(měi)每(měi)美(měi)昧(mèi) 寐(mèi) 妹(mèi) 媚(mèi) 门(mén) 闷(mèn) 们(men) 萌(ménɡ)蒙(ménɡ)檬(ménɡ)盟(ménɡ)锰(měnɡ)猛(měnɡ)梦(mènɡ)孟(mènɡ)眯(mī)醚(mí) 靡(mí) 糜(mí) 迷(mí) 谜(mí) 弥(mí) 米(mǐ)秘(mì) 觅(mì) 泌(mì) 蜜(mì) 密(mì) 幂(mì) 棉(mián) 眠(mián) 绵(mián) 冕(miǎn)免(miǎn)勉(miǎn)娩(miǎn)缅(miǎn)面(miàn) 苗(miáo) 描(miáo) 瞄(miáo) 藐(miǎo)秒(miǎo)渺(miǎo)庙(miào) 妙(miào) 蔑(miè) 灭(miè) 民(mín) 抿(mǐn)皿(mǐn)敏(mǐn)悯(mǐn)闽(mǐn)明(mínɡ)螟(mínɡ)鸣(mínɡ)铭(mínɡ)名(mínɡ)命(mìnɡ)谬(miù) 摸(mō)摹(mó) 蘑(mó) 模(mó) 膜(mó) 磨(mó) 摩(mó) 魔(mó) 抹(mǒ)末(mò) 莫(mò) 墨(mò) 默(mò) 沫(mò) 漠(mò) 寞(mò) 陌(mò) 谋(móu) 牟(móu) 某(mǒu)拇(mǔ)牡(mǔ)亩(mǔ)姆(mǔ)母(mǔ)墓(mù) 暮(mù) 幕(mù) 募(mù) 慕(mù) 木(mù) 目(mù) 睦(mù) 牧(mù) 穆(mù)拿(ná) 哪(nǎ)呐(nà) 钠(nà) 那(nà) 娜(nà) 纳(nà) 氖(nǎi)乃(nǎi)奶(nǎi)耐(nài) 奈(nài) 南(nán) 男(nán) 难(nán) 囊(nánɡ)挠(náo) 脑(nǎo)恼(nǎo)闹(nào) 淖(nào) 呢(ne) 馁(něi)内(nèi) 嫩(nèn) 能(nénɡ)妮(nī)霓(ní) 倪(ní) 泥(ní) 尼(ní) 拟(nǐ)你(nǐ)匿(nì) 腻(nì) 逆(nì) 溺(nì) 蔫(niān)拈(niān)年(nián) 碾(niǎn)撵(niǎn)捻(niǎn)念(niàn) 娘(niánɡ)酿(niànɡ)鸟(niǎo)尿(niào) 捏(niē)聂(niè) 孽(niè) 啮(niè) 镊(niè) 镍(niè) 涅(niè) 您(nín) 柠(nínɡ)狞(nínɡ)凝(nínɡ)宁(nínɡ)拧(nǐnɡ)泞(nìnɡ)牛(niú) 扭(niǔ)钮(niǔ)纽(niǔ)脓(nónɡ)浓(nónɡ)农(nónɡ)弄(nònɡ)奴(nú) 努(nǔ)怒(nù) 女(nǚ)暖(nuǎn)虐(nuè) 疟(nuè) 挪(nuó) 懦(nuò) 糯(nuò) 诺(nuò)哦(ò) 欧(ōu)鸥(ōu)殴(ōu)藕(ǒu)呕(ǒu)偶(ǒu)沤(ōu)啪(pā)趴(pā)爬(pá) 帕(pà) 怕(pà) 琶(pá) 拍(pāi)排(pái) 牌(pái) 徘(pái) 湃(pài) 派(pài) 攀(pān)潘(pān)盘(pán) 磐(pán) 盼(pàn) 畔(pàn) 判(pàn) 叛(pàn) 乓(pānɡ)庞(pánɡ)旁(pánɡ)耪(pǎnɡ)胖(pànɡ)抛(pāo)咆(páo) 刨(páo) 炮(pào) 袍(páo) 跑(pǎo)泡(pào) 呸(pēi)胚(pēi)培(péi) 裴(péi) 赔(péi) 陪(péi) 配(pèi) 佩(pèi) 沛(pèi) 喷(pēn)盆(pén) 砰(pēnɡ)抨(pēnɡ)烹(pēnɡ)澎(pénɡ)彭(pénɡ)蓬(pénɡ)棚(pénɡ)硼(pénɡ)篷(pénɡ)膨(pénɡ)朋(pénɡ)鹏(pénɡ)捧(pěnɡ)碰(pènɡ)坯(pī)砒(pī)霹(pī)批(pī)披(pī)劈(pī)琵(pí) 毗(pí) 啤(pí) 脾(pí) 疲(pí) 皮(pí) 匹(pǐ)痞(pǐ)僻(pì) 屁(pì) 譬(pì) 篇(piān)偏(piān)片(piàn) 骗(piàn) 飘(piāo)漂(piāo)瓢(piáo) 票(piào) 撇(piě)瞥(piē)拼(pīn)频(pín) 贫(pín) 品(pǐn)聘(pìn) 乒(pīnɡ)坪(pínɡ)苹(pínɡ)萍(pínɡ)平(pínɡ)凭(pínɡ)瓶(pínɡ)评(pínɡ)屏(pínɡ)坡(pō)泼(pō)颇(pō)婆(pó) 破(pò) 魄(pò) 迫(pò) 粕(pò) 剖(pōu)扑(pū)铺(pū)仆(pú) 莆(pú) 葡(pú) 菩(pú) 蒲(pú) 埔(pǔ)朴(pǔ)圃(pǔ)普(pǔ)浦(pǔ)谱(pǔ)曝(pù) 瀑(pù)期(qī)欺(qī)栖(qī)戚(qī)妻(qī)七(qī)凄(qī)漆(qī)柒(qī)沏(qī)其(qí) 棋(qí) 奇(qí) 歧(qí) 畦(qí) 崎(qí) 脐(qí) 齐(qí) 旗(qí) 祈(qí) 祁(qí) 骑(jì) 起(qǐ)岂(qǐ)乞(qǐ)企(qǐ)启(qǐ)契(qì) 砌(qì) 器(qì) 气(qì) 迄(qì) 弃(qì) 汽(qì) 泣(qì) 讫(qì) 掐(qiā)洽(qià) 牵(qiān)扦(qiān)钎(qiān)铅(qiān)千(qiān)迁(qiān)签(qiān)仟(qiān)谦(qiān)乾(qián) 黔(qián) 钱(qián) 钳(qián) 前(qián) 潜(qián) 遣(qiǎn)浅(qiǎn)谴(qiǎn)堑(qiàn) 嵌(qiàn) 欠(qiàn) 歉(qiàn) 枪(qiānɡ)呛(qiànɡ)腔(qiānɡ)羌(qiānɡ)墙(qiánɡ)蔷(qiánɡ)强(qiánɡ)抢(qiǎnɡ)橇(qiāo)锹(qiāo)敲(qiāo)悄(qiāo)桥(qiáo) 瞧(qiáo) 乔(qiáo) 侨(qiáo) 巧(qiǎo)鞘(qiào) 撬(qiào) 翘(qiào) 峭(qiào) 俏(qiào) 窍(qiào) 切(qiē)茄(qié) 且(qiě)怯(qiè) 窃(qiè) 钦(qīn)侵(qīn)亲(qīn)秦(qín) 琴(qín) 勤(qín) 芹(qín) 擒(qín) 禽(qín) 寝(qǐn)沁(qìn) 青(qīnɡ)轻(qīnɡ)氢(qīnɡ)倾(qīnɡ)卿(qīnɡ)清(qīnɡ)擎(qínɡ)晴(qínɡ)氰(qínɡ)情(qínɡ)顷(qǐnɡ)请(qǐnɡ)庆(qìnɡ)琼(qiónɡ)穷(qiónɡ)秋(qiū)丘(qiū)邱(qiū)球(qiú) 求(qiú) 囚(qiú) 酋(qiú) 泅(qiú) 趋(qū)区(qū)蛆(qū)曲(qǔ)躯(qū)屈(qū)驱(qū)渠(qú) 取(qǔ)娶(qǔ)龋(qǔ)趣(qù) 去(qù) 圈(quān)颧(quán) 权(quán) 醛(quán) 泉(quán) 全(quán) 痊(quán) 拳(quán) 犬(quǎn)券(quàn) 劝(quàn) 缺(quē)炔(ɡuì)瘸(qué) 却(què) 鹊(què) 榷(què) 确(què) 雀(què) 裙(qún) 群(qún)然(rán) 燃(rán) 冉(rǎn)染(rǎn)瓤(ránɡ)壤(rǎnɡ)攘(rǎnɡ)嚷(rǎnɡ)让(rànɡ)饶(ráo) 扰(rǎo)绕(rào) 惹(rě)热(rè) 壬(rén) 仁(rén) 人(rén) 忍(rěn)韧(rèn) 任(rèn) 认(rèn) 刃(rèn) 妊(rèn) 纫(rèn) 扔(rēnɡ)仍(rénɡ)日(rì) 戎(rónɡ)茸(rónɡ)蓉(rónɡ)荣(rónɡ)融(rónɡ)熔(rónɡ)溶(rónɡ)容(rónɡ)绒(rónɡ)冗(rǒnɡ)揉(róu) 柔(róu) 肉(ròu) 茹(rú) 蠕(rú) 儒(rú) 孺(rú) 如(rú) 辱(rǔ)乳(rǔ)汝(rǔ)入(rù) 褥(rù) 软(ruǎn)阮(ruǎn)蕊(ruǐ)瑞(ruì) 锐(ruì) 闰(rùn) 润(rùn) 若(ruò) 弱(ruò)撒(sā)洒(sǎ)萨(sà) 腮(sāi)鳃(sāi)塞(sāi)赛(sài) 三(sān)叁(sān)伞(sǎn)散(sàn) 桑(sānɡ)嗓(sǎnɡ)丧(sànɡ)搔(sāo)骚(sāo)扫(sǎo)嫂(sǎo)瑟(sè) 色(sè) 涩(sè) 森(sēn)僧(sēnɡ)莎(shā)砂(shā)杀(shā)刹(chà) 沙(shā)纱(shā)傻(shǎ)啥(shá) 煞(shà) 筛(shāi)晒(shài) 珊(shān)苫(shān)杉(shān)山(shān)删(s hān)煽(shān)衫(shān)闪(shǎn)陕(shǎn)擅(shàn) 赡(shàn) 膳(shàn) 善(shàn) 汕(shàn) 扇(shàn) 缮(shàn) 墒(shānɡ)伤(shānɡ)商(shānɡ)赏(shǎnɡ)晌(shǎnɡ)上(shànɡ)尚(shànɡ)裳(shɑnɡ)梢(shāo)捎(shāo)稍(shāo)烧(shāo)芍(sháo) 勺(sháo) 韶(sháo) 少(shǎo)哨(shào) 邵(shào) 绍(shào) 奢(s hē)赊(shē)蛇(shé) 舌(shé) 舍(shě)赦(shè) 摄(shè) 射(shè) 慑(shè) 涉(shè) 社(shè) 设(shè) 砷(shēn)申(shēn)呻(shēn)伸(shēn)身(shēn)深(shēn)娠(shēn)绅(shēn)神(shén) 沈(shěn)审(shěn)婶(shěn)甚(shèn) 肾(shèn) 慎(shèn) 渗(shèn) 声(shēnɡ)生(shēnɡ)甥(shēnɡ)牲(shēnɡ)升(shēnɡ)绳(shénɡ)省(shěnɡ)盛(shènɡ)剩(shènɡ)胜(shènɡ)圣(shènɡ)师(shī)失(shī)狮(shī)施(shī)湿(shī)诗(shī)尸(shī)虱(shī)十(shí) 石(dān)拾(shí) 时(shí) 什(shén) 食(shí) 蚀(shí) 实(shí) 识(shí) 史(shǐ)矢(shǐ)使(shǐ)屎(shǐ)驶(shǐ)始(shǐ)式(shì) 示(shì) 士(shì) 世(shì) 柿(shì) 事(shì) 拭(shì) 誓(shì) 逝(shì) 势(shì) 是(shì) 嗜(shì) 噬(shì) 适(shì) 仕(shì) 侍(shì) 释(shì) 饰(shì) 氏(shì) 市(shì) 恃(shì) 室(shì) 视(shì) 试(shì) 收(shōu)手(shǒu)首(shǒu)守(shǒu)寿(shòu) 授(shòu) 售(shòu) 受(shòu) 瘦(shòu) 兽(shòu) 蔬(shū)枢(shū)梳(shū)殊(shū)抒(shū)输(shū)叔(shū)舒(shū)淑(shū)疏(shū)书(shū)赎(shú) 孰(shú) 熟(shú) 薯(shǔ)暑(shǔ)曙(shǔ)署(shǔ)蜀(shǔ)黍(shǔ)鼠(shǔ)属(shǔ)术(shù) 述(shù) 树(shù) 束(shù) 戍(shù) 竖(shù) 墅(shù) 庶(shù) 数(shù) 漱(shù) 恕(shù) 刷(shuā)耍(shuǎ)摔(shuāi)衰(shuāi)甩(shuǎi)帅(shuài) 栓(shuān)拴(shuān)霜(shuānɡ)双(shuānɡ)爽(shuǎnɡ)谁(shuí) 水(shuǐ)睡(shuì) 税(shuì) 吮(shǔn)瞬(shùn) 顺(shùn) 舜(shùn) 说(shuō)硕(shuò) 朔(shuò) 烁(shuò) 斯(sī)撕(sī)嘶(sī)思(sī)私(sī)司(sī)丝(sī)死(sǐ)肆(sì) 寺(sì) 嗣(sì) 四(sì) 伺(sì) 似(sì) 饲(sì) 巳(sì) 松(sōnɡ)耸(sǒnɡ)怂(sǒnɡ)颂(sònɡ)送(sònɡ)宋(sònɡ)讼(sònɡ)诵(sònɡ)搜(sōu)艘(sōu)擞(sǒu)嗽(sòu) 苏(sū)酥(sū)俗(sú) 素(sù) 速(sù) 粟(sù) 僳(sù) 塑(sù) 溯(sù) 宿(sù) 诉(sù) 肃(sù) 酸(suān)蒜(suàn) 算(suàn) 虽(suī)隋(suí) 随(suí) 绥(suí) 髓(suǐ)碎(suì) 岁(suì) 穗(suì) 遂(suí) 隧(suì) 祟(suì) 孙(sūn)损(sǔn)笋(sǔn)蓑(suō)梭(suō)唆(suō)缩(suō)琐(suǒ)索(suǒ)锁(suǒ)所(suǒ)塌(tā)他(tā)它(tā)她(tā)塔(tǎ)獭(tǎ)挞(tà) 蹋(tà) 踏(tà) 胎(tāi)苔(tái) 抬(tái) 台(tái) 泰(tài) 酞(tài) 太(tài) 态(tài) 汰(tài) 坍(tān)摊(tān)贪(tān)瘫(tān)滩(tān)坛(tán) 檀(tán) 痰(tán) 潭(tán) 谭(tán) 谈(tán) 坦(tǎn)毯(tǎn) 袒(tǎn)碳(tàn) 探(tàn) 叹(tàn) 炭(tàn) 汤(tānɡ)塘(tánɡ)搪(tánɡ)堂(tánɡ)棠(tánɡ)膛(tánɡ)唐(tánɡ)糖(tánɡ)倘(tǎnɡ)躺(tǎnɡ)淌(tǎnɡ)趟(tànɡ)烫(tànɡ)掏(tāo)涛(tāo)滔(tāo)绦(tāo)萄(táo) 桃(táo) 逃(táo) 淘(táo) 陶(táo) 讨(tǎo)套(tào) 特(tè) 藤(ténɡ)腾(ténɡ)疼(ténɡ)誊(ténɡ)梯(tī)剔(tī)踢(tī)锑(tī)提(tí) 题(tí) 蹄(tí) 啼(tí) 体(tǐ)替(tì) 嚏(tì) 惕(tì) 涕(tì) 剃(tì) 屉(tì) 天(tiān)添(tiān)填(tián) 田(tián) 甜(tián) 恬(tián) 舔(tiǎn)腆(tiǎn)挑(tiāo)条(tiáo) 迢(tiáo) 眺(tiào) 跳(tiào) 贴(tiē)铁(tiě)帖(tiē)厅(tīnɡ)听(tīnɡ)烃(tīnɡ)汀(tīnɡ)廷(tínɡ)停(tínɡ)亭(tínɡ)庭(tínɡ)挺(tǐnɡ)艇(tǐnɡ)通(tōnɡ)桐(tónɡ)酮(tónɡ)瞳(tónɡ)同(tónɡ)铜(tónɡ)彤(tónɡ)童(tónɡ)桶(tǒnɡ)捅(tǒnɡ)筒(tǒnɡ)统(tǒnɡ)痛(tònɡ)偷(tōu)投(tóu) 头(tóu) 透(tòu) 凸(tū)秃(tū)突(tū)图(tú) 徒(tú) 途(tú) 涂(tú) 屠(tú) 土(tǔ)吐(tǔ)兔(tù) 湍(tuān)团(tuán) 推(t uī)颓(tuí) 腿(tuǐ)蜕(tuì) 褪(tuì) 退(tuì) 吞(tūn)屯(tún) 臀(tún) 拖(tuō)托(tuō)脱(tuō)鸵(tuó) 陀(tuó) 驮(tuó) 驼(tuó) 椭(tuǒ)妥(tuǒ)拓(tuò) 唾(tuò)挖(wā)哇(wā)蛙(wā)洼(wā)娃(wá) 瓦(wǎ)袜(wà) 歪(wāi)外(wài) 豌(wān)弯(wān)湾(wān)玩(wán) 顽(wán) 丸(wán) 烷(wán) 完(wán) 碗(wǎn) 挽(wǎn)晚(wǎn)皖(wǎn)惋(wǎn)宛(wǎn)婉(wǎn)万(wàn) 腕(wàn) 汪(wānɡ)王(wánɡ)亡(wánɡ)枉(wǎnɡ)网(wǎnɡ)往(wǎnɡ)旺(wànɡ)望(wànɡ)忘(wànɡ)妄(wànɡ)威(wēi)巍(wēi)微(wēi)危(wēi)韦(wéi) 违(wéi) 桅(wéi) 围(wéi) 唯(wéi) 惟(wéi) 为(wéi) 潍(wéi) 维(wéi) 苇(wěi)萎(wěi)委(wěi)伟(wěi) 伪(wěi)尾(wěi)纬(wěi)未(wèi) 蔚(wèi) 味(wèi) 畏(wèi) 胃(wèi) 喂(wèi) 魏(wèi) 位(wèi) 渭(wèi) 谓(wèi) 尉(wèi) 慰(wèi) 卫(wèi) 瘟(wēn)温(wēn)蚊(wén) 文(wén) 闻(wén) 纹(wén) 吻(wěn)稳(wěn)紊(wěn)问(wèn) 嗡(wēnɡ)翁(wēnɡ)瓮(wènɡ)挝(wō)蜗(wō)涡(wō)窝(wō)我(wǒ)斡(wò) 卧(wò) 握(wò) 沃(wò) 巫(wū)呜(wū)钨(wū)乌(wū)污(wū)诬(wū)屋(wū)无(wú) 芜(wú) 梧(wú) 吾(wú) 吴(wú) 毋(wú) 武(wǔ)五(wǔ)捂(wǔ)午(wǔ)舞(wǔ)伍(wǔ)侮(wǔ)坞(wù) 戊(wù) 雾(wù) 晤(wù) 物(wù) 勿(wù) 务(wù) 悟(wù) 误(wù)昔(xī)熙(xī)析(xī)西(xī)硒(xī)矽(xī)晰(xī)嘻(xī)吸(xī)锡(xī)牺(xī)稀(xī)息(xī)希(xī)悉(xī)膝(xī)夕(xī)惜(xī)熄(xī)烯(xī)溪(xī)汐(xī)犀(xī)檄(xí) 袭(xí) 席(xí) 习(xí) 媳(xí) 喜(xǐ)铣(xǐ)洗(xǐ)系(xì) 隙(xì) 戏(xì) 细(xì) 瞎(xiā)虾(xiā)匣(xiá) 霞(xiá) 辖(xiá) 暇(xiá) 峡(xiá) 侠(xiá) 狭(xiá) 下(xià) 厦(shà) 夏(xià) 吓(xià) 掀(xiān)锨(xiān)先(xiān)仙(xiān)鲜(xiān)纤(xiān)咸(xián) 贤(xián) 衔(xián) 舷(xián) 闲(xián) 涎(xián) 弦。
excel-汉字转换成拼音简拼(只取首字母)
名字转换为首字母（VBA自定义函数）1、打开EXCEL2、按 ALT+F11 ，点击插入-插入模块，在右面窗口中粘贴下面代码，直接关闭窗口3、输入公式=hztopy(A1)，填充所有单元格4、选中所有缩写，复制-选择性粘贴-数值（因为是自定义函数，只有在当前文件中可以显示结果，其他电脑因没有公式而显示错误）5、使用条件格式，检索出含有汉字的单元格:先点中一个单元格（设为D5），条件格式-新建格式规则-使用公式确定要设置格式的单元格：在下面对话框中输入公式 =LENB(D5)>LEN(D5)，自己设置格式，确定后退出，再把该单元格的格式用格式刷刷所有单元格。
有汉字的出现所设格式6、选择自定义排序-排序依据“单元格颜色”-次序“无单元格颜色”“在底端”-确定。
7、将汉字手动改写为相应的字母。
8、核对多音字。
注：以上方法只可以在当前文件夹使用，如何将宏保存，使自定义函数可以在所有文件夹中使用1、新建一个EXCEL2、按 ALT+F11 ，点击插入-插入模块，在右面窗口中粘贴下面代码，直接关闭窗口3、另存为-其他格式-文件名改为宏名称、保存类型选择“EXCEL加载宏（*,xlam）”,文件将自动保存在C:\Users\111\AppData\Roaming\Microsoft\AddIns文件夹。
4、打开需要工作的EXLEL，点击开始-EXCEL选项-加载项-转到（G）...-选中上面保存的宏名称-确定。
这样，在该电脑的所有EXCEL中，都可以直接使用自定义公式。
代码(只复制星号内的内容)******************************************************************************* Function hztopy(hzpy As String) As StringDim hzstring As String, pystring As StringDim hzpysum As Integer, hzi As Integer, hzpyhex As Integerhzstring = Trim(hzpy)hzpysum = Len(Trim(hzstring))pystring = ""For hzi = 1 To hzpysumhzpyhex = "&H" + Hex(Asc(Mid(hzstring, hzi, 1)))Select Case hzpyhexCase &HB0A1 To &HB0C4: pystring = pystring + "A"Case &HB0C5 To &HB2C0: pystring = pystring + "B"Case &HB2C1 To &HB4ED: pystring = pystring + "C"Case &HB4EE To &HB6E9: pystring = pystring + "D"Case &HB6EA To &HB7A1: pystring = pystring + "E"Case &HB7A2 To &HB8C0: pystring = pystring + "F"Case &HB8C1 To &HB9FD: pystring = pystring + "G"Case &HB9FE To &HBBF6: pystring = pystring + "H"Case &HBBF7 To &HBFA5: pystring = pystring + "J"Case &HBFA6 To &HC0AB: pystring = pystring + "K"Case &HC0AC To &HC2E7: pystring = pystring + "L"Case &HC2E8 To &HC4C2: pystring = pystring + "M"Case &HC4C3 To &HC5B5: pystring = pystring + "N"Case &HC5B6 To &HC5BD: pystring = pystring + "O"Case &HC5BE To &HC6D9: pystring = pystring + "P"Case &HC6DA To &HC8BA: pystring = pystring + "Q"Case &HC8BB To &HC8F5: pystring = pystring + "R"Case &HC8F6 To &HCBF9: pystring = pystring + "S"Case &HCBFA To &HCDD9: pystring = pystring + "T"Case &HEDC5: pystring = pystring + "T"Case &HCDDA To &HCEF3: pystring = pystring + "W"Case &HCEF4 To &HD1B8: pystring = pystring + "X"Case &HD1B9 To &HD4D0: pystring = pystring + "Y"Case &HD4D1 To &HD7F9: pystring = pystring + "Z"Case Elsepystring = pystring + Mid(hzstring, hzi, 1)End SelectNexthztopy = pystringEnd Function*******************************************************************************。
EXCEL中怎么把汉字变成拼音,并取拼音的第一个大写字母
打开Excel->工具->宏->Viaual Basic编辑器在弹出来的窗口中对着VBAproject点右键->插入->模块下面会出现一个名为"模块1"，点击在右边的空白栏中粘贴以下内容：Function pinyin(p As String) As Stringi = Asc(p)Select Case iCase -20319 To -20284: pinyin = "A"Case -20283 To -19776: pinyin = "B"Case -19775 To -19219: pinyin = "C"Case -19218 To -18711: pinyin = "D"Case -18710 To -18527: pinyin = "E"Case -18526 To -18240: pinyin = "F"Case -18239 To -17923: pinyin = "G"Case -17922 To -17418: pinyin = "H"Case -17417 To -16475: pinyin = "J"Case -16474 To -16213: pinyin = "K"Case -16212 To -15641: pinyin = "L"Case -15640 To -15166: pinyin = "M"Case -15165 To -14923: pinyin = "N"Case -14922 To -14915: pinyin = "O"Case -14914 To -14631: pinyin = "P"Case -14630 To -14150: pinyin = "Q"Case -14149 To -14091: pinyin = "R"Case -14090 To -13319: pinyin = "S"Case -13318 To -12839: pinyin = "T"Case -12838 To -12557: pinyin = "W"Case -12556 To -11848: pinyin = "X"Case -11847 To -11056: pinyin = "Y"Case -11055 To -2050: pinyin = "Z"Case Else: pinyin = pEnd SelectEnd FunctionFunction getpy(str)For i = 1 To Len(str)getpy = getpy & pinyin(Mid(str, i, 1))Next iEnd Function********复制到此结束,本行不复制*******现在转换函数已编写完成!关掉此编缉的窗口。
汉字转拼音宏
Public PY_DB(1 To 72, 1 To 94) As StringPublic PY_Index() As IntegerSub DealVal_1()Dim i As Integer, j As IntegerDim Db As VariantDim PYDB(72) As StringPYDB(0) = "-2050,-2306,-2562,-2818,-3074,-3330,-3586,-3842,-4098,-4354,-4610 ,-4866,-5122,-5378,-5634,-5890,-6146,-6402,-6658,-6914,-7170,-7426 ,-7682,-7938,-8194,-8450,-8706,-8962,-9218,-9474,-9730,-9986,-1024 7,-10498,-10754,-11010,-11266,-11522,-11778,-12034,-12290,-12546,-12802,-13058,-13314,-13570,-13826,-14082,-14338,-14594,-14850,-151 06,-15362,-15618,-15874,-16130,-16386,-16642,-16898,-17154,-17410, -17666,-17922,-18178,-18434,-18690,-18946,-19202,-19458,-19714,-19 970,-20226,"PYDB(1) = "zha1,han1,qiu2,xi1,yan3,wu2,you4,fen2,an4,can3,qing2,li2,du2,qu1, yi1,xia2,you3,chu4,dai4,lin2,she4,ao2,qi2,mi2,zhu3,Jun1,ji3,mi2,hu i1,me5,lie4,huan2,bin4,jiu1,quan2,xiu1,zi1,ji4,tiao2,ran2,mao2,kun 1,biao1,yong1,tao1,tie4,yan4,xiang3,chi1,wang3,xiao1,liang3,yan3,b a2,mei4,du2,bin4,kuan1,qia4,lou2,bi4,ke1,ge2,hou2,di3,gu3,ku1,tou2 ,jie4,bei4,gou1,rou2,ju1,jian1,man2,qiao2,da2,yang1,da2,li3,zun1,s han4,gui4,yong1,min3,man2,xue3,biao4,le4,yao2,guan1,ta3,qi2,ao2," PYDB(2) = "sao1,bian1,huang2,fu4,qiu1,e4,die2,fen4,zi1,shi1,diao1,nian2,ni2, gu4,chang1,kun1,fei1,zou1,ling2,qing1,ji4,huan4,sha1,gun3,tiao2,sh i2,jian1,lian2,li2,geng3,xun2,xiang3,jiao1,ji4,er2,wei3,jie2,gui1, tai2,hou4,fu4,su1,lu2,nian2,ping2,ba4,fang2,you2,xin1,bei4,liu2,ao 4,mou2,zan4,wu4,luan2,qiong2,chou2,qu2,luo4,ju1,Jun4,sun3,zhui1,tu o2,yuan2,mian3,wo4,chuo4,yu3,yin2,zi1,tiao2,bao1,ju3,chen4,mai2,xi an4,ai3,yin2,sha4,fei1,pei4,ji4,ting2,wen2,li4,yu2,liang4,qing3,zi 1,zhi4,su4,gong1,"PYDB(3) = "zi1,gu1,shang1,jue2,hu2,pi2,mo4,xiu1,mo4,diao1,zhi4,xie4,zuan1,li e4,chan2,lin4,zhu2,cu4,fan2,pu3,jue3,chu2,qi1,pan2,nie4,rou2,pian2 ,cuo1,duo2,ju3,zhong3,chuai4,die2,jian4,zhi2,bo2,dian3,zhi4,chi2,h uai2,chuo1,ji4,liang2,jiao1,ji1,xian1,xian3,bi4,qiao1,kui3,tai2,bo 3,jia1,tuo2,li4,shan1,fu1,zhi2,qiang1,fu1,jian3,ta1,bo1,bie2,cu4,x ue2,qiong2,dun3,cuo2,shi3,xun1,li3,ju4,xi1,jiao4,bu2,lao2,tang2,ha i3,xu3,ti2,hu2,pei1,kun1,lei4,tu2,cheng2,shai1,yan4,zhi3,ming3,xia n1,tuo2,zuo4,"PYDB(4) ="gu1,yi3,zhou4,gan1,ding3,chi3,jiang1,zhe3,nan3,zan3,zi1,lie4,ju1, jiu1,qu1,fu1,dao4,yao2,qi3,qi2,zhi2,jiao3,yi4,he2,pian1,jian3,fei3 ,zhu4,xi1,ling2,yi4,ji4,gen4,jiang4,qiu3,rou2,xu3,ci2,zan1,hou2,sh en1,zong4,lin2,can4,zi1,xi1,tiao4,li4,ba1,mi3,xian1,xi1,tang1,jie2 ,suo1,qiang3,di1,bi4,sha1,qiu2,jia1,niao3,qin1,meng2,chong1,cao2,s hou3,meng3,wei3,shao1,xi1,ze2,zhu2,lu2,ge3,fang3,ban3,zhong1,bi3,y i3,shan1,chuan2,nv4,nie4,xi4,chong1,yu2,yu2,zhou4,lai4,bo3,deng1,z an1,dian4,"PYDB(5) = "gui3,duan4,lu4,dou1,mie4,su4,chi2,bi4,li4,fei3,gou1,hou2,huang2,k ui4,zhen1,xiao1,yuan1,kong1,dan1,bi4,tuo4,qian2,ruo4,zhu4,qie4,ze2 ,qing4,xiao3,shao1,pa2,gang4,shi4,Jun1,zheng1,quan2,yan2,xian3,bi4 ,kou4,chi1,bian1,jia1,tiao2,si4,li4,gou3,ze2,sheng1,da2,po3,qiong2 ,hu4,zi3,zhao4,jian3,ji1,du3,ji2,yu2,zhu2,shi4,xia4,qing4,ying1,fo u3,qu2,du4,li2,mie4,lian2,chan2,meng3,huo4,shan4,pan2,hui4,peng2,m ao2,shuai4,zhang1,zhong1,xiang4,xi1,tang2,piao1,cao2,huang2,shi4,p ang2,tang2,chi1,xi1,yuan2,ma2,"PYDB(6) = "mang3,man3,ao2,qin2,mou2,bian1,you2,lou2,you2,yu2,sou1,fu4,ke1,ku i2,fu2,nan3,rong2,chun1,meng3,lang2,wan1,quan2,tiao2,pi2,yi4,guo1, guo3,fei1,yu4,xi1,qi2,qing1,qiang1,fu2,chu2,li2,wu2,shao1,zhe1,she n4,mou2,yang2,jiao1,qi2,kuo4,ting2,qu1,si1,zhi4,nao2,jia2,qiong2,y ou4,cheng1,ling2,qiu1,zha4,ran2,you2,li4,ke1,gu1,han1,chi1,yin3,do u3,gong1,jie4,hao2,xian3,rui4,pi2,fu2,meng2,ge4,hui1,chai4,ji3,qiu 2,qian2,hu3,pin2,ru2,hao4,sang3,man1,nie4,zhuan1,e4,han4,ke1,ying3 ,he2,jie2,"PYDB(7) = "hang2,qi2,han1,tan2,ao2,kui4,guo1,ning2,ling2,dan1,ding1,die2,mo4 ,nou4,jiang3,lou2,ou3,tang1,lao4,huo1,si4,chao4,zi3,lei3,jin1,cun1 ,Jun1,xu1,ya3,pan4,ru2,qiang3,zhe3,chi3,lan2,bian3,lv3,bao3,bei4,d a1,duo1,ju1,bi4,ti4,chu3,biao3,jian3,lian3,cheng2,lian2,ken4,ge1,j ia2,dang1,pan4,mei4,jin1,ren4,na4,cha3,yi1,yu3,ju4,xun1,yu2,ke1,do u4,tiao3,yao3,bian3,zhun1,qiong2,xi1,song3,yi4,qu2,dian1,pi3,dian4 ,yi4,lai4,ban1,chou1,yin3,long2,zhai4,ying3,luo3,biao1,huang2,ji2, ban1,mo4,chi4,"PYDB(8) = "sao4,jia3,lou4,chai4,hou2,yi4,la4,dan1,yu1,yu3,wei3,gu4,fei4,zhu2 ,sha1,xian2,cuo2,wu4,lao2,zhi4,yi2,ya3,jia1,xuan2,zhu4,pao4,zha4,d a5,ke1,gan1,you2,li4,shan4,li4,jie1,ding1,bing4,guan4,lu4,hu4,yu4, jiu4,jiao1,liao2,liu4,zhe4,ying1,jian1,yao4,wu4,mei2,ci2,e4,hu2,ch un2,bei1,an1,miao2,wu3,ti2,xian2,yu4,hu2,li2,bo2,luan2,xiu1,gua1,z hi4,er2,si1,chi1,qu2,lu2,dong1,gu1,zhen4,bao3,yuan1,jiu1,yong3,hu4 ,die2,po2,xi1,hao4,jiao3,gui1,rang2,fu4,nian2,se4,ji4,zhen3,"PYDB(9) ="ren3,ke1,lang2,fu1,ji1,lv3,shu2,mo4,zi3,bi3,zhi4,cuo2,shen3,zhong 1,biao1,cha3,yi4,zhuo2,huo4,deng4,qiang1,cuan1,pu3,lan2,dui4,lu3,p u2,jue2,tan2,di2,xuan4,zu2,yong1,luo2,man4,tang2,biao1,bin1,jia1,y i4,liu2,na2,juan1,ge2,mo4,mei2,fei4,qiang1,lou4,ai1,huan2,sou1,cha 1,e4,si1,kai3,qie4,zi1,tan2,juan3,pei2,huo1,gu4,kun1,ke4,de2,ben1, nuo4,qiang1,a1,ju1,qin3,lang2,jian3,kai1,liu3,lue4,cuo4,e2,gao4,li 3,zeng4,keng1,te4,lai2,lao2,ru2,an3,tang1,chong4,se4,zheng1,yao2,s ha1,"PYDB(10) = "ha1,quan2,hua2,diu1,ding4,zhu1,kai3,yin1,diao4,cheng1,ye2,nao2,ji a2,cheng2,you3,er3,lao3,kao4,duo2,pi2,ni2,bi4,ta1,xuan4,shi4,shuo4 ,dian4,tan3,mu4,yue4,bo2,bu1,po3,ke1,gu3,zheng1,yu4,ba3,huo3,tou3, kang4,fang1,qian2,ban3,ju4,tai4,bu4,nv3,chai1,men2,shan1,chuan4,tu 3,liao3,zhao1,po1,yi3,ga2,jin1,juan1,guan4,he2,zeng1,ji1,li2,lan3, pi2,yan3,li4,gu3,gang1,fu2,tuan3,wan3,she1,zhen3,fan4,tian2,quan3, bi4,ding1,gu3,lin2,kan4,cheng1,piao3,ming2,ke1,mao4,kui2,sou3,rui4 ,pi4,sui1,"PYDB(11) = "ni4,ya2,suo1,di4,jian3,lai4,mou2,chi1,zi4,sui1,yi2,yuan1,sheng3,d an1,miao3,dun3,kou1,mian3,xu1,fu3,fu2,zhi3,kan1,bo2,meng2,ca3,jian g1,deng4,dun1,qu2,qing4,sang3,gun3,zhe2,bian3,xuan4,di4,jie2,zhou2 ,chen3,ding4,bei4,dui4,qi4,wo4,ge4,nao2,dong4,zhai4,qiao1,xia2,man g2,xing2,fu2,tuo2,la2,di3,tong2,zha3,long2,li4,ai4,fa3,feng1,bian1 ,zhuo2,ya4,dun4,che1,hua1,dang4,gan1,ji1,miao3,xue2,ta4,yu4,yu4,ga ng4,men4,mao4,dui4,qi4,te4,min3,qian1,que4,zi4,yang4,nin2,nv4,hui4 ,jia2,dui4,"PYDB(12) = "tan3,te4,rang2,xi3,zhuo2,xi4,chan2,qi2,tiao1,zhen1,ci2,zhi1,mi2,z uo4,fu2,hu4,qu1,zhi3,xian1,si4,shi4,fei1,hu4,jiong1,hu4,li4,xi1,xu 4,tao1,si4,cuan4,jue2,xian3,sui4,fan2,yu4,yi4,yun4,shang1,man4,liu 1,tui4,bian1,xuan1,bao1,duan4,wei1,yu4,hu2,yan4,chao1,men4,han2,wu 4,yang2,ye4,tai2,xuan4,zhu4,hu1,shi2,qiang4,dun4,wei3,yang2,yi3,li u2,ni3,jing1,zhan1,mao2,pei4,yu2,lan2,ji1,fei3,hu2,gu1,gou4,shu1,b iao1,biao1,sou1,ju4,sa4,biao1,xi1,xin1,sha4,yi1,xi1,yu2,lin4,lian2 ,"PYDB(13) = "shan1,sao4,meng2,gu3,chuai4,zhi4,teng2,bin4,lv3,ge2,ying4,cheng2, shu4,e4,wa4,mian3,nan3,cou4,jian4,ding4,zong1,yu2,fei2,yan1,jing1, niao4,wan3,pao1,cuo3,luo2,tun2,mi3,zhen4,pian2,hai3,sa4,kuai4,yan1 ,dong4,guang1,jing4,zhi1,qu2,zhen1,gua1,zuo4,zhou4,shen4,jia3,lu2, ka3,dong4,long2,qian3,yao2,na4,zhun1,gong1,tai4,ruan3,jing3,huang1 ,rong2,wo4,yue4,guo2,yuan2,you3,die2,du2,jiao3,chi4,fan3,yun1,ke4, yin1,ya4,dong1,chuan1,xian1,dao1,pie1,qu2,pu3,lu5,chang3,shu1,san1 ,jian4,cui4,mu2,mao4,bo4,ge2,"PYDB(14) = "bai1,suo1,qie4,kao4,pian1,jian1,ju4,ji1,gu4,wu3,gu3,mao2,pin4,jia ng4,jian4,qu4,jin4,gou4,yu2,di2,xi2,ji4,chan1,fu4,dan3,ji1,qiu2,la i4,zhen4,jin4,gai1,zi1,zhi4,yi2,kuang4,shi4,ben1,nang3,xi1,yao4,xu n1,tun1,ming2,ai4,kui2,xuan1,gui3,han2,bu1,hui1,yan4,chao2,ye4,she ng4,qi2,ni4,chang3,yu4,mao3,zan3,he2,gui4,yun2,xin1,ze4,gao3,tan2, hao4,gan4,la2,ga1,po1,pi4,zeng4,beng4,bu4,ling2,ou1,zang1,jian3,ga i4,deng3,kan1,ji2,ji3,jia2,qiang1,jian1,wei4,lin2,lu4,cou4,zi1,chu o4,"PYDB(15) = "wang3,nian3,zhe2,lu4,quan2,zhi4,shi4,yao2,li4,hu1,zhen3,yi4,zhi3, lu2,ke1,gu1,e4,ren4,yi4,bin4,ji2,dan1,piao3,lian4,yun3,tian3,shang 1,cu2,mo4,ao2,you2,cha2,bo4,lin3,yan2,lei2,yuan2,ju2,xi1,zun1,lu3, qin2,qiao2,jue2,tuo2,qing2,yue4,gan3,hu2,zhu1,tang2,chu1,qi4,qiang 2,jin3,xie4,zhu1,rong2,bin1,shuo4,gao3,cui1,gao1,xie4,sun3,ta4,fei 3,zhen1,ying2,mei2,xuan4,ju3,cha2,lv2,chen4,chui2,duan4,qiu1,ju3,p in3,ji2,lan3,lian4,zha1,nan2,zhen1,cou4,ju1,di4,jian4,guo3,liang2, chui2,luo2,"PYDB(16) = "zhao4,qian4,du2,fen2,chu3,ling2,suo1,zi3,jue2,fu2,gu4,fan4,xu3,an 1,juan4,luan2,jie2,gui4,heng2,hua4,jiu4,gua1,ting3,qi1,guang1,zhen 1,zhi4,rao2,ya1,lao3,kao3,cheng1,tuo2,li4,di3,gou3,ling2,zhi1,tuo4 ,zhi3,you4,xiao1,xia2,lu2,ping2,jiu4,long2,zhe4,zhi4,nai4,zhu4,pa2 ,fang1,xiao1,cong1,cheng2,chu3,jian3,rui4,yao3,miao3,pi2,li4,ma4,c ha1,qi3,shao2,wu4,tao1,yun4,wei3,wen4,zan4,bi4,lu4,qu2,can4,pu2,zh ang1,xuan2,cong1,cui3,ying1,huang2,jin3,tang2,ai4,nao3,xia2,yuan4, yu2,mao4,ju1,chen1,"PYDB(17) = "wan3,cong2,yan3,kun1,hu3,qi2,ying1,qi2,lian3,hui1,xi3,luo4,yao2,h eng2,ya2,xu1,gong3,er3,jia1,min2,po4,dai4,dian4,long2,ke1,jue2,min 2,bin1,wei3,ji1,ding1,yong1,zai1,chuan1,ji1,yao1,zuan3,huan2,qiao1 ,qian3,jiang1,zeng1,liao2,xie2,sao1,miao4,lei2,man4,piao1,bin1,jia n1,yi4,li2,gao3,ru4,zhen3,jin4,min2,zhui4,gou1,bian4,si1,hui4,miao 3,ti2,xiang1,ke4,zi1,wan3,quan3,liu3,shou4,duo3,gun3,shang4,fei1,q i3,ling2,ti2,xiao1,geng3,jiang4,hang2,ku4,dai4,chu4,fu2,zhou4,fu2, xie4,gan4,shu1,pi1,yun2,"PYDB(18) = "kuang4,wan2,ge1,zhou4,yu1,jiao3,xiang1,ji4,chan3,cong1,biao1,shan 4,liu2,ao4,wu4,zhi4,can1,zhui1,ke4,qi2,li2,pian2,hua2,xiao1,dai4,n u2,yi4,zou1,fu4,si4,zang3,bao1,jue2,jie2,zi1,nu2,fu2,ga2,ga3,shuan g1,mo2,niao3,bi4,shan4,xi1,zhang1,lei2,chang2,piao2,qiang2,yan1,li 2,chi1,pin2,ai4,pi4,mo2,gou4,wu4,ting2,yuan2,ao3,nu3,chan2,bi4,cha ng1,jie2,biao3,jing4,e1,wei3,di4,suo1,xian2,wa1,ping1,li3,cha4,pin 1,jiao1,luan2,shu1,rao2,ya4,qie4,shan1,zhou2,da2,si4,yu2,niu1,gui1,zi3,jin4,"PYDB(19) = "bi3,yu4,wu3,yan2,fei1,shuo4,chu1,yu4,bi4,fu2,mi3,nu3,jing4,chan4, ju4,xi3,chan2,e1,ji1,zhi3,kao1,zhi4,tuan4,hui4,xun2,la1,sui4,miao3 ,xie4,ju4,lin2,xian1,liu2,ta1,gou4,ao2,xia2,qiu2,huang2,chuan2,lu4 ,huan4,wei1,kui2,qun1,ti4,xiao1,qiu2,li3,bu1,pang2,hou4,dai4,jing4 ,jia1,er3,yi3,ze2,jiong3,wu3,ya4,zou3,jian3,jian3,huan2,qian1,liao 2,wu4,qian1,qian1,ning2,chen2,you4,mi4,dang4,gui3,bao3,ba4,hao4,fe n4,yue4,ying2,xie4,han4,zhuo2,hao2,bi4,pu2,ru2,lian2,chan2,dan4,li 3,sui1,"PYDB(20) = "lai4,chan2,tong2,shao4,shan1,si1,shu4,gan3,xuan2,lu4,yi1,zhu1,lia n4,huan4,luo4,hu1,cao2,lan3,xiao1,ying2,huang2,ming2,pang1,tang2,f u3,xiu4,bi4,hun4,ta1,ru4,li4,pu3,ying2,mang3,she4,ke4,qin2,yan4,me i2,wo4,xuan4,jian1,pen2,xu4,huang2,sou1,qiu1,mian3,yan1,xie4,shuan 4,lu4,guan4,shen3,cong2,fei2,gan4,mian3,pi4,zhuo1,du2,song1,xi1,qi 2,zhu3,huan4,mei3,xi1,bang1,cen2,juan1,zhuo2,wei2,lai2,wu2,su4,ru4 ,xun2,hu3,liu2,jiang4,xun2,tao2,hui4,xu4,ji4,zhu1,hui2,yin1,zhen1, jia1,lie4,wei3,huan2,"PYDB(21) = "jing1,min3,hong2,tuo2,pan4,xuan4,luo4,mao3,ling2,duo4,si4,yang1,l u2,long2,shu4,gan1,le4,wei2,hang4,wen4,bian4,gu3,mi4,dun4,mian3,mu 4,yuan2,feng1,cha4,si4,qi4,san1,qiang1,pan2,zhuang4,kan4,que4,tian 2,he2,que4,qu4,e4,hun1,wen2,xi4,chang1,yu4,lang2,jiu1,kun3,lv2,ta4 ,kang1,min3,hong2,wei2,yan2,shuan1,hui1,tian3,meng3,lin3,chu4,chon g1,qiao2,jing3,yong1,qie4,su4,bi4,qiao3,zhui4,leng4,e4,kui4,yun4,c ui4,hu1,chou2,wang3,chang3,fei3,xing4,qie4,quan1,ti4,yi4,kun3,kui1 ,qian1,song3,bei4,yun4,ke4,"PYDB(22) = "xun2,kai3,ce4,yan1,tong4,yi2,yi4,chao1,fu2,ni2,zuo4,yang4,da2,pen g1,chu4,hu4,niu3,bian4,song1,chuang4,chang4,kai4,wu3,chong1,ou4,zh i4,wu3,chan4,cun3,dao1,shu4,ying1,lin3,xie4,chan2,jin3,ao2,geng1,b i4,yu3,an1,tuo3,xiang2,xiu1,pao2,gui3,wu3,pi3,nang2,zhuan4,san3,ji n3,xiu1,mo2,sou1,zha5,hun2,yu2,bo1,xiang3,yi2,chi4,yu4,ren4,xi4,tu n2,tang2,shi4,dong1,yin2,sun1,huo3,chuan3,huan1,xun1,xie4,liao2,ju e2,jing4,zhang1,nao2,mei2,wei4,wei3,cha2,hu2,mi2,cu4,she1,ni2,luo2 ,guo3,yi1,suan1,"PYDB(23) = "yin2,xian3,yu2,li4,juan4,bi4,sun1,shou4,kuai4,rong2,fei4,pao2,xia 2,yun3,niu3,ma3,guang3,an4,qiu2,fan3,san1,qu2,jiao3,zheng1,yao2,hu ang2,chang2,xi3,lai2,hou4,yang2,xun4,cu2,pang2,chi4,dian1,yi2,bin1 ,deng4,lin2,zhang4,ji2,song1,sheng4,mei2,zi1,lou3,cuo2,yu2,wei2,za i3,wai3,yao3,rong2,jue2,kong1,guo1,xiao2,gu4,yan1,song1,lai2,lao2, zheng1,xun2,qiao2,dong4,yi4,min2,mao3,gou3,dai4,xiu4,jia3,dong1,ke3,hu4,ba1,lan2,cen2,ao4,xian4,ya2,qu1,qi2,qian1,qi3,ji2,fan1,fu2,z hang4,man4,wo4,wei2,"PYDB(24) = "guo2,ze2,dao4,tang3,pei4,zhi4,wei2,huan2,yu3,qing1,yu3,you4,ling2 ,hu2,lun2,nan1,jian3,wei2,nang1,huo4,cha1,ru2,pi1,sai1,yi1,jue2,ji n4,hao1,deng1,ceng1,lu1,qin2,o1,jiao4,chuai4,pu1,liao2,jue1,peng1, mi4,di1,sou3,beng1,ying1,qi1,piao4,cao2,lei5,pei4,chi1,tong1,hei1, suo1,ai4,ai4,dia3,hao2,en4,a2,ge2,suo1,chen1,he1,nie4,ke1,du1,su4, ao2,qin2,hui4,wo1,ku4,lou5,jie1,chi4,yin1,sou1,jiu1,kui4,yong2,jie 1,kui2,li2,nan2,da1,die2,chuo4,shua1,li4,lang1,ding4,bo5,dan4,yo1, "PYDB(25) = "sha4,cui4,hu1,tao2,zhou1,zhuan4,lin2,miao1,nuo4,ze2,feng3,ji1,zuo 4,xi1,zao4,suo3,zha1,en2,geng3,lao4,chi1,mai4,mou1,gen2,nong2,zha4 ,mi1,mie1,ji4,duo3,kuai4,pai4,yi1,xiu1,yue3,guang1,ci1,bi4,xiao1,y i2,lie3,da1,hui1,shen3,ji1,kuang1,si1,you1,nao2,duo1,ning2,dong1,l ing4,gua1,ga1,ka1,za1,yin3,qin4,guo1,bei5,bi3,e5,li4,tai3,yi4,mu2, fu1,yao1,a1,zha4,le4,dao1,kou4,ji1,chi4,bu3,shi4,dai4,tui1,yi4,nan g3,zuan4,huo1,zhuo2,xing3,pi3,huan4,gan3,cuan1,zun3,lu1,xie2,zhe2, "PYDB(26) = "han4,zhi2,ying1,luo4,sang3,nuo4,zhan3,shuo4,jian1,chuai1,en4,shu1 ,yuan4,kui2,bing4,xuan1,an3,yu2,qin4,ya4,zha1,die2,guan4,qian2,lie 4,pou2,ju1,bai3,guo2,ji3,na4,ai2,ye2,tian4,Jun4,lv3,yi4,za1,jiao3, jie2,niu4,pin1,fu3,chen1,tuan2,men2,ti2,gan1,ga4,liao4,you2,pao2,z ang4,xi1,yi4,da1,lian2,kuang3,yi4,nong4,mi2,nie4,fan2,heng2,qu2,hu o4,li2,gao3,xian3,xun1,ru2,tai2,hao1,bi4,sou3,weng4,yi4,wei1,hong1 ,xie4,hong2,qi2,fan1,meng2,ji2,zui4,rui2,jue2,xun4,hui4,liao3,xu5, kou4,qu2,"PYDB(27) = "lin4,cu4,lian3,xi3,dou1,meng2,su4,yu4,ying2,lang4,shuo4,jian1,ban g4,li2,ji2,hao1,weng3,bei4,en1,mo4,ru4,shi1,zhen1,jia1,xuan1,pai4, lou2,ting2,pa1,bao3,e4,xi3,kui4,qi4,kai3,chan3,wei1,xiang1,shen4,f eng1,qia1,han4,gu1,ying2,wan3,jian1,dang4,zu1,yan1,cui4,dan4,tu2,f u2,bi4,huan2,yu2,tie1,chang1,shu1,ba2,qi1,nai4,jin3,song1,xi1,qi2, jing1,chun2,ying1,lang4,guan3,shen1,di2,you2,sui1,piao3,xian1,tu2, li4,you2,mei2,e2,you3,wo1,shi4,bi2,kan3,zhou4,hong2,sun1,mai3,jin4 ,gen4,qian2,"PYDB(28) = "ying2,luo4,jiang1,chong1,jiao1,qi2,ming2,xun2,hui4,quan2,xing4,re n3,fu2,qiao2,ting2,zhu1,hui2,tong2,ju3,zi3,bi4,rao2,yi2,qian4,tiao 2,min2,qiong2,ying2,mao2,yin4,niao3,ling2,fu2,chi2,qing3,ran3,ju1, mu4,ba2,long2,pie3,gan1,mo4,yi3,kou1,zhu4,bian4,shan1,qi2,qian4,wu 4,qin2,cong1,chang2,xian4,rui4,zhi3,pi2,ju4,e4,li4,ji4,fei4,yun2,yuan2,fu2,xiang1,qi3,xiong1,wan2,ji1,qian1,du4,nai3,jiao1,cao3,yi4, pi2,xin1,chi2,liang2,yong1,man4,yuan2,ge2,hou4,leng2,yin1,die2,ku1 ,dai4,sao4,tu4,peng2,"PYDB(29) = "nian4,pi2,yi4,an3,zhi2,yuan4,lie4,xun1,guo1,shi2,cheng2,yin2,gai1 ,nao3,shang3,shan1,kai3,dong4,die2,ya1,ao4,mu3,ni2,tuo2,di3,che4,l u2,dian4,long3,gan1,ban3,qi2,li4,yi2,pi3,kuang4,zhen4,ge1,wu1,xu1, he4,yong1,ji1,shu2,fa2,e4,ben4,qiu2,ben3,bian4,si1,chang4,dang4,sh an1,jian4,jue2,xie4,sou3,xie2,xu4,meng3,ge3,he2,shao4,qu2,mai4,hua n4,chu2,feng1,ling2,zou1,shan4,po2,zhang1,yin2,yan1,juan4,yan3,tan 2,pi2,fu2,xi1,gao4,ying3,li4,yun4,xun2,qie4,kuai4,zhu1,zhi4,jia2,t ai2,di3,"PYDB(30) = "ye4,bei4,pi1,bing3,fang1,wu1,mang2,kuang4,qiong2,han2,xi2,wei3,hu ang2,wei1,pi2,chui2,zou1,nie4,zhi4,gai1,xing2,bei1,zuo4,yan2,ban3, jing3,qian1,wu4,zuo3,jin3,dan1,chen4,zhan1,yan4,jue2,qiao2,zen4,ji an3,zhe2,mi4,shi4,su4,dang3,mo2,pian3,zi1,di4,an1,xuan1,yu4,e4,ye4 ,xue4,jian4,chen2,sui4,chan3,shen3,yu2,wei3,zhuo2,zou1,ei1,kuang2, gao4,qiao4,xu3,hun4,zheng4,quan2,gou4,shen1,hui1,jie2,gua4,lei3,ku ang1,yi2,qu1,zhao4,di3,he1,gu3,ne4,ju4,ou1,shan4,hong4,jie2,yan2,m ing2,zhong3,ping2,song1,"PYDB(31) = "xian3,lie4,hu4,liang3,lei2,luo3,ying2,bing3,pou2,luan2,xie4,mao4, gun3,bo2,yan3,wen2,si4,su4,fu2,fu2,hong1,pu2,bao1,kui2,chan3,guo2, hong2,xun4,xi1,di2,cuan1,yue4,zu3,qian1,she2,tun3,tong2,dan1,xuan1 ,tong2,jiu4,jiao1,jian4,jing3,xi1,chi4,nuo2,bin1,tang3,lv3,zong3,w ei1,ji4,xie2,yan3,fen4,ju4,kong1,guan1,ti4,bi3,wo1,luo3,shu1,zhuo1 ,pai2,ruo4,qian4,feng4,si4,yong3,ping1,yu3,li3,qiu2,li4,yan3,chou2 ,mou2,nong2,jiao3,chai2,tiao1,yi4,zhu1,kan3,kua3,you4,er4,ji2,ga1, ni4,tuo2,tong2,"PYDB(32) = "gou1,yi4,you1,ka3,ning4,zhu4,kang4,cang1,chang1,wu3,wa3,ya2,pi3,y u3,ren4,mu4,yi4,sa1,le4,zhang3,ding1,dan1,wang3,tong2,yi4,huo1,qia o1,jue2,piao1,kuai3,wan1,yan3,ji1,la4,kai3,gui4,ku1,jing3,wen3,yi4 ,ce4,you3,gua4,ze2,bian3,kui4,gui3,po3,qu1,yan4,ye4,si1,jue2,yan3, cuo4,she4,ze4,gu3,se4,bo2,mi3,qi2,ji1,nie4,nai4,ji2,dian3,tao2,gao 1,yu4,kui2,yin4,xin4,di1,zhi1,yao2,yao1,tuo1,bi3,pie3,yu2,shu4,e4, nao1,ge2,cheng2,gen4,pi1,sa4,nian4,gai4,wu1,ji1,chu4,"PYDB(33) = "zuo4,zuo4,zuo4,zuo4,zha4,zuo3,zuo3,zuo2,zun1,zun1,zui4,zui4,zui4, zui3,zuan3,zuan4,zu3,zu3,zu3,zu3,zu2,zu2,zu2,zu1,zou4,zou4,zou3,zo u1,zong4,zong3,zong1,zong1,zong1,zong1,zong1,zi4,zi4,zi4,zi3,zi3,z i3,zai3,zi3,zi1,zi1,zi1,zi1,zi1,zi1,zi1,zhuo2,zhuo2,zhe5,zhuo2,zhu o2,zhuo2,zhuo2,zhuo1,zhuo2,zhuo1,zhuo1,zhun3,zhun1,zhui4,zhui4,zhui4,zhui1,zhui1,zhui1,zhuang4,zhuang4,zhuang4,zhuang1,zhuang1,zhuan g1,zhuang1,zhuan4,zuan4,zhuan4,zhuan3,zhuan1,zhuan1,zhuai4,zhao3,z hua1,zhu4,zhu4,zhu4,zhu4,,,,,,"PYDB(34) = "zhu4,zhu4,zhu4,zhu4,zhu4,zhu4,zhe5,zhu3,zhu3,zhu3,zhu3,zhu3,zhu2, zhu2,zhu2,zhu1,zhu1,zhu1,zhu1,zhu1,zhu1,zhu1,zhou4,zhou4,zhou4,zho u4,zhou4,zhou3,zhou3,zhou2,zhou1,zhou1,zhou1,zhou1,zhou1,zhou1,zho ng4,zhong4,zhong4,zhong3,zhong3,zhong1,zhong1,zhong1,zhong1,zhong1 ,zhong1,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi 4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi4,zhi3,zhi3,zhi1,zhi3,zhi3,zhi3,zhi3 ,zhi2,zhi2,zhi2,zhi2,zhi2,zhi2,zhi2,zhi1,zhi1,zhi1,zhi1,zhi1,zhi1, zhi1,zi1,zhi1,zhi1,zhi1,zheng4,zheng4,zheng4,zhen1,"PYDB(35) = "zheng4,zheng4,zheng3,zheng3,zheng1,zheng1,zheng1,zheng1,zheng1,zh eng4,zheng1,zhen4,zhen4,zhen4,zhen4,zhen3,zhen3,zhen3,zhen1,zhen1, zhen1,zhen1,zhen1,zhen1,zhen1,zhen1,zhen1,zhe4,zhe4,zhe4,zhe3,zhe3 ,zhe2,zhe2,zhe2,zhe2,zhe1,zhao4,zhao4,zhao4,zhao4,zhao4,zhao4,zhao 3,zhao3,zhao1,zhao1,zhang4,zhang4,zhang4,zhang4,zhang4,zhang4,zhan g4,zhang4,zhang3,zhang3,zhang1,zhang1,zhang1,zhang1,zhang1,zhan4,z han4,zhan4,zhan4,zhan4,zhan4,zhan4,zhan3,zhan3,nian3,zhan3,zhan3,z han1,zhan1,zhan1,zhan1,zhan1,zhai4,zhai4,zhai3,zhai2,zhai1,zhai1,z ha4,zha4,zha4,za3,zha4,shan1,zha3,zha2,zha2,"PYDB(36) = "zha2,zha2,zha1,zha1,zha1,zeng4,ceng2,zeng1,zeng1,zen3,zei2,ze2,ze 2,ze2,ze2,zao4,zao4,zao4,zao4,zao4,zao4,zao3,zao3,zao3,zao3,zao3,z ao2,zao1,zao1,zang4,zang1,zang1,zan4,zan4,zan3,zan2,zai4,zai4,zai3 ,zai3,zai1,zai1,zai1,za2,za2,za1,yun4,yun4,yun1,yun4,yun4,yun4,yun 3,yun3,yun2,yun2,yun2,yun2,yue4,yue4,yue4,yue4,yue4,yao4,yue4,yue4 ,yue1,yue1,yuan4,yuan4,yuan4,yuan4,yuan3,yuan2,yuan2,yuan2,yuan2,y uan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan2,yuan1,yuan1,yuan1,y u4,yu4,yu4,yu4,yu4,yu4,"PYDB(37) = "yu4,yu4,yu4,yu4,yu4,yu4,yu4,yu4,yu4,xu1,yu4,yu4,yu4,yu4,yu3,yu3,y u3,yu3,yu3,yu3,yu3,yu2,yu3,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2,yu2 ,yu2,yu2,yu2,yu2,yu1,yu1,you4,you4,you4,you4,you4,you4,you3,you3,y ou3,you2,you2,you2,you2,you2,you2,you2,you1,you1,you1,you1,yong4,y ong3,yong3,yong3,yong3,yong3,yong3,yong3,yong3,yong1,yong1,yong1,y ong1,yong4,yong1,yo1,ying4,ying4,ying3,ying3,ying2,ying2,ying2,yin g2,ying2,ying2,ying2,ying2,ying1,ying1,ying1,ying1,ying1,ying1,yin 4,"PYDB(38) = "yin3,yin3,yin3,yin3,yin2,yin2,yin2,yin2,yin1,yin1,yin1,yin1,yin1, yin1,yin1,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4, yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi4,yi3,yi3,yi3,yi3,yi3,yi3,yi3,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi2,yi1,yi1, yi1,yi1,yi1,yi1,yi1,yi1,ye4,ye4,ye4,ye4,ye4,ye4,ye4,ye4,ye3,ye3,ye 3,ye2,ye1,ye1,ye1,yao4,yao4,yao4,yao3,yao3,yao2,yao2,yao2,yao2,yao 2,yao2,"PYDB(39) = "yao2,yao1,yao1,yao1,yang4,yang4,yang3,yang3,yang3,yang3,yang2,yan g2,yang2,yang2,yang2,yang2,yang2,yang1,yang1,yang1,yang1,yan4,yan4 ,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan4,yan3,yan3,yan3, yan3,yan3,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,yan2,y an1,yan1,yan1,yan1,yan1,ya4,ya4,ya3,ya3,ya2,ya2,ya2,ya2,ya2,ya2,ya 1,ya5,ya1,ya1,ya1,ya1,xun4,xun4,xun4,xun4,xun4,xun4,xun2,xun4,xun2 ,xun2,xun2,xun2,xun1,xun1,xue4,xue3,xue2,xue2,xue1,xue1,xuan4,xuan 4,xuan3,xuan3,"PYDB(40) = "xuan2,xuan2,xuan2,xuan1,xuan1,xuan1,xu4,xu4,xu4,xu4,xu4,chu4,xu4, xu4,xu4,xu4,xu4,xu3,xu2,xu1,xu1,xu1,xu1,xu1,xu1,xiu4,xiu4,xiu4,xiu 4,xiu4,xiu3,xiu1,xiu1,xiu1,xiong2,xiong2,xiong1,xiong1,xiong1,xion g1,xiong1,xing4,xing4,xing4,xing4,xing3,hang2,xing2,xing2,xing2,xi ng2,xing4,xing1,xing1,xing1,xing1,xin4,xin4,xin1,xin1,xin1,xin1,xi n1,xin1,xin1,xin1,xie4,xie4,xie4,xie4,xie4,xie4,xie4,xie4,xie3,xie 2,xie2,xie2,xie2,xie2,jia1,xie2,xie2,xie1,xie1,xie1,xie1,xiao4,xia o4,xiao4,xiao1,xiao4,xiao4,xiao3,"PYDB(41) = "xiao3,xiao2,xiao1,xiao1,xiao1,xiao1,xiao1,xue1,xiao1,xiao1,xiao1, xiang4,xiang4,xiang4,xiang4,xiang4,xiang4,xiang3,xiang3,xiang3,xia ng2,xiang2,xiang2,xiang1,xiang1,xiang1,xiang1,xiang1,xiang1,xiang1 ,xiang4,xian4,xian4,xian4,xian4,xian4,xian4,xian4,xian4,xian4,xian 4,xian3,xian3,xian2,xian2,xian2,xian2,xian2,xian2,xian2,xian2,xian 1,xian1,xian1,xian1,xian1,xian1,xia4,xia4,sha4,xia4,xia2,xia2,xia2 ,xia2,xia2,xia2,xia2,xia1,xia1,xi4,xi4,xi4,xi4,xi3,xi3,xi3,xi2,xi2 ,xi2,xi2,xi2,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1," PYDB(42) = "xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,xi1,wu4,wu4,wu4,wu4,wu4,w u4,wu4,wu4,wu4,wu3,wu3,wu3,wu3,wu3,wu3,wu3,wu2,wu2,wu2,wu2,wu2,wu2 ,wu1,wu1,wu1,wu1,wu1,wu1,wu1,wo4,wo4,wo4,wo4,wo3,wo1,wo1,wo1,wo1,w eng4,weng1,weng1,wen4,wen3,wen3,wen3,wen2,wen2,wen2,wen2,wen1,wen1 ,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4,wei4, wei3,wei3,wei3,wei3,wei3,wei3,wei3,wei2,wei2,wei2,wei2,wei2,wei2,w ei2,wei2,wei2,wei1,wei1,wei1,"PYDB(43) = "wei1,wang4,wang4,wang4,wang4,wang3,wang3,wang3,wang2,wang2,wang1, wan4,wan4,wan3,wan3,wan3,wan3,wan3,wan3,wan3,wan2,wan2,wan2,wan2,w an2,wan1,wan1,wan1,wai4,wai1,wa4,wa3,wa2,wa1,wa1,wa5,wa1,tuo4,tuo4 ,tuo3,tuo3,tuo2,tuo2,tuo2,tuo2,tuo1,tuo1,tuo1,tun2,tun2,tun1,tui4,tui4,tui4,tui3,tui2,tui1,tuan2,tuan1,tu4,tu3,tu3,tu2,tu2,tu2,tu2,t u2,tu1,tu1,tu1,tou4,tou2,tou2,tou1,tong4,tong3,tong3,tong3,tong3,t ong2,tong2,tong2,tong2,tong2,tong2,tong2,tong1,ting3,ting3,ting2,t ing2,ting2,ting2,ting1,"PYDB(44) = "ting1,ting1,ting1,tie1,tie3,tie1,tiao4,tiao4,tiao2,tiao2,tiao1,ti an3,tian3,tian2,tian2,tian2,tian2,tian1,tian1,ti4,ti4,ti4,ti4,ti4, ti4,ti3,ti2,ti2,ti2,ti2,ti1,ti1,ti1,ti1,teng2,teng2,teng2,teng2,te 4,tao4,tao3,tao2,tao2,tao2,tao2,tao2,tao1,tao1,tao1,tao1,tang4,tan g4,tang3,tang3,tang3,tang2,tang2,tang2,tang2,tang2,tang2,tang2,tan g1,tan4,tan4,tan4,tan4,tan3,tan3,tan3,tan2,tan2,tan2,tan2,tan2,tan 2,tan1,tan1,tan1,tan1,tan1,tai4,tai4,tai4,tai4,tai4,tai2,tai2,tai2 ,tai1,ta4,ta4,ta4,ta3,"PYDB(45) = "ta3,ta1,ta1,ta1,ta1,suo3,suo3,suo3,suo3,suo1,suo1,suo1,suo1,sun3, sun3,sun1,sui4,sui4,sui2,sui4,sui4,sui4,sui3,sui2,sui2,sui2,sui1,s uan4,suan4,suan1,su4,su4,xiu3,su4,su4,su4,su4,su4,su4,su2,su1,su1, sou4,sou3,sou1,sou1,song4,song4,song4,song4,song4,song3,song3,song 1,si4,si4,si4,si4,si4,si4,si4,si4,si3,si1,si1,si1,si1,si1,si1,si1, shuo4,shuo4,shuo4,shuo1,shun4,shun4,shun4,shun3,shui4,shui4,shui3, shui2,shuang3,shuang1,shuang1,shuan1,shuan1,shuai4,shuai3,shuai1,s huai1,shua3,shua1,shu4,"PYDB(46) = "shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu4,shu3,shu3,shu3, shu3,shu3,shu3,shu3,shu3,shu2,shu2,shu2,shu1,shu1,shu1,shu1,shu1,s hu1,shu1,shu1,shu1,shu1,shu1,shou4,shou4,shou4,shou4,shou4,shou4,s hou3,shou3,shou3,shou1,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi 4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4,shi4 ,shi4,shi4,shi3,shi3,shi3,shi3,shi3,shi3,shi2,shi2,shi2,shi2,shi2, shi2,shi2,shi2,shi2,shi1,shi1,shi1,shi1,shi1,shi1,shi1,shi1,sheng4 ,sheng4,sheng4,sheng4,sheng3,"PYDB(47) = "sheng2,sheng1,sheng1,sheng1,sheng1,sheng1,shen4,shen4,shen4,shen4 ,shen3,shen3,shen3,shen2,shen1,shen1,shen1,shen1,shen1,shen1,shen1 ,shen1,she4,she4,she4,she4,she4,she4,she4,she3,she2,she2,she1,she1 ,shao4,shao4,shao4,shao3,shao2,shao2,shao2,shao1,shao1,shao1,shao1 ,shang5,shang4,shang4,shang3,shang3,shang1,shang1,shang1,shan4,sha n4,shan4,shan4,shan4,shan4,shan4,shan3,shan3,shan1,shan1,shan1,sha n1,shan1,shan1,shan1,shai4,shai1,sha4,sha2,sha3,sha1,sha1,cha4,sha 1,sha1,sha1,seng1,sen1,se4,se4,se4,sao3,sao3,sao1,sao1,sang4,sang3 ,sang1,san4,san3,"PYDB(48) = "san1,san1,sai4,sai1,sai1,sai1,sa4,sa3,sa1,ruo4,ruo4,run4,run4,rui 4,rui4,rui3,ruan3,ruan3,ru4,ru4,ru3,ru3,ru3,ru2,ru2,ru2,ru2,ru2,rou4,rou2,rou2,rong3,rong2,rong2,rong2,rong2,rong2,rong2,rong2,rong2 ,rong2,ri4,reng2,reng1,ren4,ren4,ren4,ren4,ren4,ren4,ren3,ren2,ren 2,ren2,re4,re3,rao4,rao3,rao2,rang4,rang3,rang3,rang3,rang2,ran3,r an3,ran2,ran2,qun2,qun2,que4,que4,que4,que4,que4,que2,gui4,que1,qu an4,quan4,quan3,quan2,quan2,quan2,quan2,quan2,quan2,quan2,quan1,qu 4,qu4,qu3,qu3,qu3,"PYDB(49) = "qu2,qu1,qu1,qu1,qu3,qu1,qu1,qu1,qiu2,qiu2,qiu2,qiu2,qiu2,qiu1,qiu 1,qiu1,qiong2,qiong2,qing4,qing3,qing3,qing2,qing2,qing2,qing2,qin g1,qing1,qing1,qing1,qing1,qing1,qin4,qin3,qin2,qin2,qin2,qin2,qin 2,qin2,qin1,qin1,qin1,qie4,qie4,qie3,qie2,qie1,qiao4,qiao4,qiao4,q iao4,qiao4,qiao4,qiao3,qiao2,qiao2,qiao2,qiao2,qiao1,qiao1,qiao1,q iao1,qiang3,qiang2,qiang2,qiang2,qiang1,qiang1,qiang4,qiang1,qian4 ,qian4,qian4,qian4,qian3,qian3,qian3,qian2,qian2,qian2,qian2,qian2 ,qian2,qian1,qian1,qian1,qian1,qian1,qian1,qian1,qian1,qian1,qia4, qia4,"PYDB(50) = "qia1,qi4,qi4,qi4,qi4,qi4,qi4,qi4,qi4,qi4,qi3,qi3,qi3,qi3,qi3,qi2, qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi2,qi1,qi1,qi1,qi1,qi1,qi 1,qi1,qi1,qi1,qi1,bao4,pu4,pu3,pu3,pu3,pu3,pu3,pu3,pu2,pu2,pu2,pu2 ,pu2,pu4,pu1,pou1,po4,po4,po4,po4,po2,po1,po1,po1,ping2,ping2,ping 2,ping2,ping2,ping2,ping2,ping2,ping1,pin4,pin3,pin2,pin2,pin1,pie 1,pie3,piao4,piao2,piao1,piao1,pian4,pian4,pian1,pian1,pi4,pi4,pi4 ,pi3,pi3,pi2,pi2,pi2,pi2,"PYDB(51) = "pi2,pi2,pi1,pi1,pi1,pi1,pi1,pi1,peng4,peng3,peng2,peng2,peng2,pen g2,peng2,peng2,peng2,peng2,peng2,peng1,peng1,peng1,pen2,pen1,pei4, pei4,pei4,pei2,pei2,pei2,pei2,pei1,pei1,pao4,pao3,pao2,pao4,pao2,p ao2,pao1,pang4,pang3,pang2,pang2,pang1,pan4,pan4,pan4,pan4,pan2,pa n2,pan1,pan1,pai4,pai4,pai2,pai2,pai2,pai1,pa2,pa4,pa4,pa2,pa1,pa1 ,ou1,ou3,ou3,ou3,ou1,ou1,ou1,o4,nuo4,nuo4,nuo4,nuo2,nue4,nue4,nuan 3,nv3,nu4,nu3,nu2,nong4,nong2,nong2,nong2,niu3,niu3,niu3,niu2,ning 4,ning3,"PYDB(52) = "ning2,ning2,ning2,ning2,nin2,nie4,nie4,nie4,nie4,nie4,nie4,nie1,n iao4,niao3,niang4,niang2,nian4,nian3,nian3,nian3,nian2,nian1,nian1 ,ni4,ni4,ni4,ni4,ni3,ni3,ni2,ni2,ni2,ni2,ni1,neng2,nen4,nei4,nei3, ne5,nao4,nao4,nao3,nao3,nao2,nang2,nan2,nan2,nan2,nai4,nai4,nai3,n ai3,nai3,na4,na4,na4,na4,na4,na3,na2,mu4,mu4,mu4,mu4,mu4,mu4,mu4,m u4,mu4,mu4,mu3,mu3,mu3,mu3,mu3,mou3,mou2,mou2,mo4,mo4,mo4,mo4,mo4, mo4,mo4,mo4,mo3,mo2,mo2,mo2,mo2,mo2,mo2,mo2,"PYDB(53) = "mo1,miu4,ming4,ming2,ming2,ming2,ming2,ming2,min3,min3,min3,min3, min3,min2,mie4,mie4,miao4,miao4,miao3,miao3,miao3,miao2,miao2,miao2,mian4,mian3,mian3,mian3,mian3,mian3,mian2,mian2,mian2,mi4,mi4,mi 4,mi4,mi4,mi4,mi3,mi2,mi2,mi2,mi2,mi2,mi2,mi1,meng4,meng4,meng3,me ng3,meng2,meng2,meng2,meng2,men5,men4,men2,mei4,mei4,mei4,mei4,mei 3,mei3,mei3,mei2,mei2,mei2,mei2,mei2,mei2,mei2,mei2,mei2,me5,mao4, mao4,mao4,mao4,mao4,mao3,mao3,mao2,mao2,mao2,mao2,mao1,mang3,mang2 ,mang2,mang2,mang2,mang2,man4,"PYDB(54) = "man4,man4,man4,man4,man3,man2,man2,man2,mai4,mai4,mai4,mai4,mai3, mai2,ma5,ma5,ma4,ma3,ma3,ma3,ma3,ma2,ma1,luo4,luo4,luo4,luo4,luo3, luo2,luo2,luo2,luo2,luo2,luo2,luo2,lun4,lun2,lun2,lun2,lun2,lun2,l un2,lue4,lue3,luan4,luan3,luan2,luan2,luan2,luan2,lv4,lv4,lv4,lv4, lv4,lv4,lv3,lv3,lv3,lv3,lv3,lv3,lv3,lv2,lu4,lu4,lu4,lu4,lu4,lu4,lu 4,lu4,lu4,lu4,lu4,lu3,lu3,lu3,lu3,lu2,lu2,lu2,lu2,lu2,lou4,lou4,lo u3,lou3,lou2,lou2,long3,long3,long3,long2,"PYDB(55) = "long2,long2,long2,long2,long2,liu4,liu3,liu2,liu2,liu2,liu2,liu2, liu2,liu2,liu2,liu1,ling4,ling4,ling3,ling3,ling2,ling2,ling2,ling 2,ling2,ling2,ling2,ling2,ling2,ling2,lin1,lin4,lin4,lin3,lin2,lin 2,lin2,lin2,lin2,lin2,lin2,lin2,lie4,lie4,lie4,lie4,lie4,liao4,lia o4,liao4,liao4,le5,liao2,liao2,liao2,liao2,liao2,liao2,liao2,liao2 ,liang4,liang4,liang4,liang4,liang4,liang3,liang2,liang2,liang2,li ang2,liang2,lian4,lian4,lian4,lian4,lian3,lian3,lian2,lian2,lian2, lian2,lian2,lian2,lian2,lian2,liang3,li3,li2,li4,li4,li4,li4,li4,l i4,"PYDB(56) = "li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li4,li3,li3,li3,l i3,li3,li2,li2,li2,li2,li2,li2,li2,li2,leng3,leng2,leng2,lei4,lei4 ,lei4,lei4,lei3,lei3,lei4,lei3,lei3,lei2,lei2,le4,le4,lao4,lao4,la o4,lao3,lao3,lao3,lao2,lao2,lao1,lang4,lang3,lang2,lang2,lang2,lan g2,lang2,lan4,lan4,lan3,lan3,lan3,lan3,lan2,lan2,lan2,lan2,lan2,la n2,lan2,lan2,lan2,lai4,lai2,lai2,la1,la4,la4,la4,la3,la1,la1,kuo4, kuo4,kuo4,kuo4,kun4,kun3,kun1,kun1,kui4,kui4,kui4,"PYDB(57) = "gui1,kui2,kui2,kui2,kui1,kui1,kui1,kui1,kuang4,kuang4,kuang4,kuan g4,kuang4,kuang2,kuang1,kuang1,kuan3,kuan1,kuai4,kuai4,kuai4,kuai4 ,kua4,kua4,kua4,kua3,kua1,ku4,ku4,ku4,ku3,ku1,ku1,ku1,kou4,kou4,ko u3,kou1,kong4,kong3,kong3,kong1,keng1,keng1,ken3,ken3,ken3,ken3,ke 4,ke4,ke4,ke4,ke3,ke3,hai1,ke2,ke1,ke1,ke1,ke1,ke1,ke1,ke3,kao4,ka o3,kao3,kao3,kang4,kang4,kang4,kang2,kang1,kang1,kang1,kan4,kan3,k an3,kan1,kan1,kan1,kai3,kai3,kai3,kai1,kai1,ge1,ka3,ka1,ka1,Jun4,J un4,xun4,Jun4,Jun4,"PYDB(58) = "Jun4,Jun1,Jun1,Jun1,Jun1,Jun1,jue2,jue2,jue2,jiao4,jue2,jue4,jue2 ,jue2,jue2,jue1,juan4,juan4,juan4,juan4,juan1,juan1,juan1,ju4,ju4,。
excel_汉字转换成拼音简拼(只取首字母)
excel_汉字转换成拼音简拼(只取首字母)名称转换为首字母(VBA自定义函数)1，打开EXCEL2，按ALT+F11，单击插入-插入模块，在右窗口粘贴以下代码，直接关闭窗口3，输入公式=hztopy(A1)，填充所有单元格4，选择所有缩写，复制-粘贴特殊值(因为它是自定义函数，只有结果可以显示在当前文件中，而其他计算机显示错误是因为5.使用条件格式检索包含中文字符的单元格:首先单击一个单元格(设置为D5)。
条件格式-新格式规则-使用公式确定要格式化的单元格:在下面的对话框中输入公式= LEMB(D5)> LEN(D5)，自己设置格式，确认后退出，然后用单元格的格式刷所有单元格汉字外观的格式设置为6。
选择自定义排序-按“单元格颜色”排序-排序“无单元格颜色”和“底部”-确定7，手动将汉字改写成相应的字母8、检查复音字符注意:上述方法只能在当前文件夹中使用。
如何保存宏以便自定义函数可以在所有文件夹中使用？1.创建新的EXCEL2。
按ALT+F11，单击插入-插入模块，并在右侧窗口中粘贴以下代码。
直接关闭窗口3，另存为-其他格式-文件名更改为宏名，保存类型选择” EXCEL加载项(*，xlam)”，文件将自动保存在c: \ \用户\ \ 111 \ \ appdata \ \ road ing \ \ Microsoft \ \ addins文件夹中4.打开需要工作的EXL，然后单击开始-扩展选项-加载项-转到(G)...-选择上面保存的宏名-确定这样，在这台计算机的所有EXCEL中，可以直接使用自定义公式。
代码(只复制星号的内容)* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *函数Hz topy(hzpy As String)As String Dim hzstring As String，py String As StringDim hzpy sum As Integer，hzi As Integer，hzpyhex As Integer hzstring = Trim(hzpy)hzpy sum = Len(Trim(hzstring))py String = \For hzi = 1 To hzpy sumhzpyhex = \ Select Case hzpyhexCase & HB 案例&HB2C1至&HB4ED: pystring = pystring + \案例&HB4EE至&HB6E9: pystring = pystring + \案例&HB6EA至&HB7A1: pystring = pystring + \案例&HB7A2至&HB8C0: pystring = pystring + \案例&HB8C1至&HB9FD: pystring = pystring + \案例&HB9FE至&HBBF6: pystring = pystring + \案例&HBBF7至&HBFA5: pystring = pystring 案例&HC2E8至&HC4C2: pystring = pystring + \案例&HC4C3至&HC5B5: pystring = pystring + \案例&HC5B6至&HC5BD:pystring = pystring + \案例&HC5BE至&HC6D9: pystring = pystring + \案例&HC6DA至&HC8BA: pystring = pystring + \案例&HC8BB至&HC8F5: pystring = pystring + \案例&HC8F6至&HCBF9: pystring = pystringCase & HCDDA To & HCEF3:py string = py string+\ Case & HCEF4 To & HD1B 8:py string = py string+\ Case & HD1B 9 To & HD4D 0:py string = py string+\ Case & HD4D 1 To & HD7F 9:py string = py string+\ Case Elsepy string = py string+Mid(Hz string，hzi，1)结束选择下一个hztopy = pystring结束。
excel汉字转换成拼音简拼（只取首字母）
名字转换为首字母（VBA自定义函数）1、打开EXCE L2、按 ALT+F11 ，点击插入-插入模块，在右面窗口中粘贴下面代码，直接关闭窗口3、输入公式=hztopy(A1)，填充所有单元格4、选中所有缩写，复制-选择性粘贴-数值（因为是自定义函数，只有在当前文件中可以显示结果，其他电脑因没有公式而显示错误）5、使用条件格式，检索出含有汉字的单元格:先点中一个单元格（设为D5），条件格式-新建格式规则-使用公式确定要设置格式的单元格：在下面对话框中输入公式=LENB(D5)>LEN(D5)，自己设置格式，确定后退出，再把该单元格的格式用格式刷刷所有单元格。
有汉字的出现所设格式6、选择自定义排序-排序依据“单元格颜色”-次序“无单元格颜色”“在底端”-确定。
7、将汉字手动改写为相应的字母。
8、核对多音字。
注：以上方法只可以在当前文件夹使用，如何将宏保存，使自定义函数可以在所有文件夹中使用1、新建一个EX CEL2、按 ALT+F11 ，点击插入-插入模块，在右面窗口中粘贴下面代码，直接关闭窗口3、另存为-其他格式-文件名改为宏名称、保存类型选择“EXCEL加载宏（*,xlam）”,文件将自动保存在C:\Users\111\AppDat a\Roamin g\Micros oft\AddIns文件夹。
4、打开需要工作的EXLE L，点击开始-EXCEL选项-加载项-转到（G）...-选中上面保存的宏名称-确定。
这样，在该电脑的所有EXCE L中，都可以直接使用自定义公式。
代码(只复制星号内的内容)******************************************************************************* Functi on hztopy(hzpy As String) As StringDim hzstri ng As String, pystri ng As StringDim hzpysu m As Intege r, hzi As Intege r, hzpyhe x As Intege rhzstri ng = Trim(hzpy)hzpysu m = Len(Trim(hzstri ng))pystri ng = ""For hzi = 1 To hzpysu mhzpyhe x = "&H" + Hex(Asc(Mid(hzstri ng, hzi, 1)))Select Case hzpyhe xCase &HB0A1To &HB0C4: pystri ng = pystri ng + "A"Case &HB0C5To &HB2C0: pystri ng = pystri ng + "B"Case &HB2C1To &HB4ED: pystri ng = pystri ng + "C"Case &HB4EETo &HB6E9: pystri ng = pystri ng + "D"Case &HB6EATo &HB7A1: pystri ng = pystri ng + "E"Case &HB7A2To &HB8C0: pystri ng = pystri ng + "F"Case &HB8C1To &HB9FD: pystri ng = pystri ng + "G"Case &HB9FETo &HBBF6: pystri ng = pystri ng + "H"Case &HBBF7To &HBFA5: pystri ng = pystri ng + "J"Case &HBFA6To &HC0AB: pystri ng = pystri ng + "K"Case &HC0ACTo &HC2E7: pystri ng = pystri ng + "L"Case &HC2E8To &HC4C2: pystri ng = pystri ng + "M"Case &HC4C3To &HC5B5: pystri ng = pystri ng + "N"Case &HC5B6To &HC5BD: pystri ng = pystri ng + "O"Case &HC5BETo &HC6D9: pystri ng = pystri ng + "P"Case &HC6DATo &HC8BA: pystri ng = pystri ng + "Q"Case &HC8BBTo &HC8F5: pystri ng = pystri ng + "R"Case &HC8F6To &HCBF9: pystri ng = pystri ng + "S"Case &HCBFATo &HCDD9: pystri ng = pystri ng + "T"Case &HEDC5: pystri ng = pystri ng + "T"Case &HCDDATo &HCEF3: pystri ng = pystri ng + "W"Case &HCEF4To &HD1B8: pystri ng = pystri ng + "X"Case &HD1B9To &HD4D0: pystri ng = pystri ng + "Y"Case &HD4D1To &HD7F9: pystri ng = pystri ng + "Z"Case Elsep ystri ng = pystri ng + Mid(hzstri ng, hzi, 1)End SelectNexthztopy = pystri ngEnd Functi on*******************************************************************************。
excel_汉字转换成拼音简拼(只取首字母)
名字转换为首字母（VBA自定义函数）1、打开EXCEL2、按 ALT+F11 ，点击插入-插入模块，在右面窗口中粘贴下面代码，直接关闭窗口3、输入公式=hztopy(A1)，填充所有单元格4、选中所有缩写，复制-选择性粘贴-数值（因为是自定义函数，只有在当前文件中可以显示结果，其他电脑因没有公式而显示错误）5、使用条件格式，检索出含有汉字的单元格:先点中一个单元格（设为D5），条件格式-新建格式规则-使用公式确定要设置格式的单元格：在下面对话框中输入公式 =LENB(D5)>LEN(D5)，自己设置格式，确定后退出，再把该单元格的格式用格式刷刷所有单元格。
有汉字的出现所设格式6、选择自定义排序-排序依据“单元格颜色”-次序“无单元格颜色”“在底端”-确定。
7、将汉字手动改写为相应的字母。
8、核对多音字。
注：以上方法只可以在当前文件夹使用，如何将宏保存，使自定义函数可以在所有文件夹中使用1、新建一个EXCEL2、按 ALT+F11 ，点击插入-插入模块，在右面窗口中粘贴下面代码，直接关闭窗口3、另存为-其他格式-文件名改为宏名称、保存类型选择“EXCEL加载宏（*,xlam）”,文件将自动保存在C:\Users\111\AppData\Roaming\Microsoft\AddIns文件夹。
4、打开需要工作的EXLEL，点击开始-EXCEL选项-加载项-转到（G）...-选中上面保存的宏名称-确定。
这样，在该电脑的所有EXCEL中，都可以直接使用自定义公式。
代码(只复制星号内的内容)******************************************************************************* Function hztopy(hzpy As String) As StringDim hzstring As String, pystring As StringDim hzpysum As Integer, hzi As Integer, hzpyhex As Integerhzstring = Trim(hzpy)hzpysum = Len(Trim(hzstring))pystring = ""For hzi = 1 To hzpysumhzpyhex = "&H" + Hex(Asc(Mid(hzstring, hzi, 1)))Select Case hzpyhexCase &HB0A1 To &HB0C4: pystring = pystring + "A"Case &HB0C5 To &HB2C0: pystring = pystring + "B"Case &HB2C1 To &HB4ED: pystring = pystring + "C"Case &HB4EE To &HB6E9: pystring = pystring + "D"Case &HB6EA To &HB7A1: pystring = pystring + "E"Case &HB7A2 To &HB8C0: pystring = pystring + "F"Case &HB8C1 To &HB9FD: pystring = pystring + "G"Case &HB9FE To &HBBF6: pystring = pystring + "H"Case &HBBF7 To &HBFA5: pystring = pystring + "J"Case &HBFA6 To &HC0AB: pystring = pystring + "K"Case &HC0AC To &HC2E7: pystring = pystring + "L"Case &HC2E8 To &HC4C2: pystring = pystring + "M"Case &HC4C3 To &HC5B5: pystring = pystring + "N"Case &HC5B6 To &HC5BD: pystring = pystring + "O"Case &HC5BE To &HC6D9: pystring = pystring + "P"Case &HC6DA To &HC8BA: pystring = pystring + "Q"Case &HC8BB To &HC8F5: pystring = pystring + "R"Case &HC8F6 To &HCBF9: pystring = pystring + "S"Case &HCBFA To &HCDD9: pystring = pystring + "T"Case &HEDC5: pystring = pystring + "T"Case &HCDDA To &HCEF3: pystring = pystring + "W"Case &HCEF4 To &HD1B8: pystring = pystring + "X"Case &HD1B9 To &HD4D0: pystring = pystring + "Y"Case &HD4D1 To &HD7F9: pystring = pystring + "Z"Case Elsepystring = pystring + Mid(hzstring, hzi, 1)End SelectNexthztopy = pystringEnd Function*******************************************************************************。
excel汉字转字母函数
excel汉字转字母函数EXCEL汉字转字母函数Excel的汉字转字母函数是用来实现在Excel中输入汉字，自动转换成拼音的功能，这一功能对于网站开发项目中的中文名称转换成拼音字母来说，可以节省很多时间。
汉字转字母函数可以使用EXCEL自带函数=CHAR()来实现，也可以使用VBA函数来实现。
Excel自带函数=CHAR()：这种实现方式非常简单，只需要在列字母中输入=CHAR（）函数，然后在括号中输入汉字的Unicode码即可，Excel就会自动转换成对应的字母拼写。
例如：我们要将汉字“中国”转换成拼音，可以在列中输入以下函数：=CHAR（20013）&CHAR（22269），此时，Excel会将函数转换成“zhongguo”。
VBA函数：除了利用Excel自带的字符函数=CHAR（）实现汉字转换拼音字母，我们还可以使用VBA函数来实现。
步骤：1、在Excel的文件中，点击“工具”——“宏”——“Visual Basic 编辑器”，弹出VBA编辑器；2、点击VBA编辑器中的“插入”，再点击“模块”；3、在模块编辑器中，输入以下代码：Function myChar(Text As String)myChar = StrConv(Text, vbNarrow)End Function4、保存并关闭编辑器；5、在Excel编辑器中，点击“工具”——“宏”，添加要调用的函数，选择我们刚刚所添加的myChar函数；6、点击确定，在Excel中就可以使用刚刚添加的myChar函数了：例如：我们要将汉字“中国”转换成拼音，可以在列中输入以下函数：=myChar（“中国”），此时，Excel会将函数转换成“zhongguo”。
excel2010汉字转拼音的方法
excel2010汉字转拼音的方法在Excel中录入好数据以后，会有一些情况需要汉字转拼音，这个在Excel中也是可以考代码实现的。
下面是由店铺分享的excel2010 汉字转拼音的方法，希望对你有用。
excel2010 汉字转拼音的方法：汉字转拼音步骤1：启动Excel 2003(其它版本请仿照操作)，打开相应的工作表;汉字转拼音步骤2：执行“工具→宏→Visual Basic编辑器”命令(或者直接按“Alt+F11”组合键)，进入Visual Basic编辑状态;汉字转拼音步骤3：执行“插入→模块”命令，插入一个新模块。
再双击插入的模块，进入模块代码编辑状态;汉字转拼音步骤4：将代码输入其中;Function pinyin(p As String) As Stringi = Asc(p)Select Case iCase -20319 To -20318: pinyin = "a "Case -20317 To -20305: pinyin = "ai "Case -20304 To -20296: pinyin = "an "Case -20295 To -20293: pinyin = "ang "Case -20292 To -20284: pinyin = "ao "Case -20283 To -20266: pinyin = "ba "Case -20265 To -20258: pinyin = "bai "Case -20257 To -20243: pinyin = "ban "Case -20242 To -20231: pinyin = "bang "Case -20230 To -20052: pinyin = "bao "Case -20051 To -20037: pinyin = "bei "Case -20036 To -20033: pinyin = "ben "Case -20032 To -20027: pinyin = "beng "Case -20026 To -20003: pinyin = "bi "Case -20002 To -19991: pinyin = "bian " Case -19990 To -19987: pinyin = "biao " Case -19986 To -19983: pinyin = "bie " Case -19982 To -19977: pinyin = "bin " Case -19976 To -19806: pinyin = "bing " Case -19805 To -19785: pinyin = "bo " Case -19784 To -19776: pinyin = "bu " Case -19775 To -19775: pinyin = "ca " Case -19774 To -19764: pinyin = "cai " Case -19763 To -19757: pinyin = "can " Case -19756 To -19752: pinyin = "cang " Case -19751 To -19747: pinyin = "cao " Case -19746 To -19742: pinyin = "ce " Case -19741 To -19740: pinyin = "ceng " Case -19739 To -19729: pinyin = "cha " Case -19728 To -19726: pinyin = "chai " Case -19725 To -19716: pinyin = "chan " Case -19715 To -19541: pinyin = "chang " Case -19540 To -19532: pinyin = "chao " Case -19531 To -19526: pinyin = "che " Case -19525 To -19516: pinyin = "chen " Case -19515 To -19501: pinyin = "cheng " Case -19500 To -19485: pinyin = "chi " Case -19484 To -19480: pinyin = "chong " Case -19479 To -19468: pinyin = "chou " Case -19467 To -19290: pinyin = "chu " Case -19289 To -19289: pinyin = "chuai " Case -19288 To -19282: pinyin = "chuan " Case -19281 To -19276: pinyin = "chuang " Case -19275 To -19271: pinyin = "chui "Case -19270 To -19264: pinyin = "chun " Case -19263 To -19262: pinyin = "chuo " Case -19261 To -19250: pinyin = "ci " Case -19249 To -19244: pinyin = "cong " Case -19243 To -19243: pinyin = "cou " Case -19242 To -19239: pinyin = "cu " Case -19238 To -19236: pinyin = "cuan " Case -19235 To -19228: pinyin = "cui " Case -19227 To -19225: pinyin = "cun " Case -19224 To -19219: pinyin = "cuo " Case -19218 To -19213: pinyin = "da " Case -19212 To -19039: pinyin = "dai " Case -19038 To -19024: pinyin = "dan " Case -19023 To -19019: pinyin = "dang " Case -19018 To -19007: pinyin = "dao " Case -19006 To -19004: pinyin = "de " Case -19003 To -18997: pinyin = "deng " Case -18996 To -18978: pinyin = "di " Case -18977 To -18962: pinyin = "dian " Case -18961 To -18953: pinyin = "diao " Case -18952 To -18784: pinyin = "die " Case -18783 To -18775: pinyin = "ding " Case -18774 To -18774: pinyin = "diu " Case -18773 To -18527: pinyin = "dong " Case -18526 To -18519: pinyin = "fa " Case -18518 To -18502: pinyin = "fan " Case -18501 To -18491: pinyin = "fang " Case -18490 To -18479: pinyin = "fei " Case -18478 To -18464: pinyin = "fen " Case -18463 To -18449: pinyin = "feng "Case -18448 To -18448: pinyin = "fo " Case -18447 To -18447: pinyin = "fou " Case -18446 To -18240: pinyin = "fu " Case -18239 To -18238: pinyin = "ga " Case -18237 To -18232: pinyin = "gai " Case -18231 To -18221: pinyin = "gan " Case -18220 To -18212: pinyin = "gang " Case -18211 To -18202: pinyin = "gao " Case -18201 To -18185: pinyin = "ge " Case -18184 To -18184: pinyin = "gei " Case -18183 To -18182: pinyin = "gen " Case -18181 To -18013: pinyin = "geng " Case -18012 To -17998: pinyin = "gong " Case -17997 To -17989: pinyin = "gou " Case -17988 To -17971: pinyin = "gu " Case -17970 To -17965: pinyin = "gua " Case -17964 To -17962: pinyin = "guai " Case -17961 To -17951: pinyin = "guan " Case -17950 To -17948: pinyin = "guang " Case -17947 To -17932: pinyin = "gui " Case -17931 To -17929: pinyin = "gun " Case -17928 To -17923: pinyin = "guo " Case -17922 To -17760: pinyin = "ha " Case -17759 To -17753: pinyin = "hai " Case -17752 To -17734: pinyin = "han " Case -17733 To -17731: pinyin = "hang " Case -17730 To -17722: pinyin = "hao " Case -17721 To -17704: pinyin = "he " Case -17703 To -17702: pinyin = "hei " Case -17701 To -17698: pinyin = "hen "Case -17697 To -17693: pinyin = "heng " Case -17692 To -17684: pinyin = "hong " Case -17683 To -17677: pinyin = "hou " Case -17676 To -17497: pinyin = "hu " Case -17496 To -17488: pinyin = "hua " Case -17487 To -17483: pinyin = "huai " Case -17482 To -17469: pinyin = "huan " Case -17468 To -17455: pinyin = "huang " Case -17454 To -17434: pinyin = "hui " Case -17433 To -17428: pinyin = "hun " Case -17427 To -17418: pinyin = "huo " Case -17417 To -17203: pinyin = "ji " Case -17202 To -17186: pinyin = "jia " Case -17185 To -16984: pinyin = "jian " Case -16983 To -16971: pinyin = "jiang " Case -16970 To -16943: pinyin = "jiao " Case -16942 To -16916: pinyin = "jie " Case -16915 To -16734: pinyin = "jin " Case -16733 To -16709: pinyin = "jing " Case -16708 To -16707: pinyin = "jiong " Case -16706 To -16690: pinyin = "jiu " Case -16689 To -16665: pinyin = "ju " Case -16664 To -16658: pinyin = "juan " Case -16657 To -16648: pinyin = "jue " Case -16647 To -16475: pinyin = "jun " Case -16474 To -16471: pinyin = "ka " Case -16470 To -16466: pinyin = "kai " Case -16465 To -16460: pinyin = "kan " Case -16459 To -16453: pinyin = "kang " Case -16452 To -16449: pinyin = "kao "Case -16448 To -16434: pinyin = "ke " Case -16433 To -16430: pinyin = "ken " Case -16429 To -16428: pinyin = "keng " Case -16427 To -16424: pinyin = "kong " Case -16423 To -16420: pinyin = "kou " Case -16419 To -16413: pinyin = "ku " Case -16412 To -16408: pinyin = "kua " Case -16407 To -16404: pinyin = "kuai " Case -16403 To -16402: pinyin = "kuan " Case -16401 To -16394: pinyin = "kuang " Case -16393 To -16221: pinyin = "kui " Case -16220 To -16217: pinyin = "kun " Case -16216 To -16213: pinyin = "kuo " Case -16212 To -16206: pinyin = "la " Case -16205 To -16203: pinyin = "lai " Case -16202 To -16188: pinyin = "lan " Case -16187 To -16181: pinyin = "lang " Case -16180 To -16172: pinyin = "lao " Case -16171 To -16170: pinyin = "le " Case -16169 To -16159: pinyin = "lei " Case -16158 To -16156: pinyin = "leng " Case -16155 To -15960: pinyin = "li " Case -15959 To -15959: pinyin = "lia " Case -15958 To -15945: pinyin = "lian " Case -15944 To -15934: pinyin = "liang " Case -15933 To -15921: pinyin = "liao " Case -15920 To -15916: pinyin = "lie " Case -15915 To -15904: pinyin = "lin " Case -15903 To -15890: pinyin = "ling " Case -15889 To -15879: pinyin = "liu "Case -15707 To -15702: pinyin = "lou " Case -15701 To -15682: pinyin = "lu " Case -15681 To -15668: pinyin = "lv " Case -15667 To -15662: pinyin = "luan " Case -15661 To -15660: pinyin = "lue " Case -15659 To -15653: pinyin = "lun " Case -15652 To -15641: pinyin = "luo " Case -15640 To -15632: pinyin = "ma " Case -15631 To -15626: pinyin = "mai " Case -15625 To -15455: pinyin = "man " Case -15454 To -15449: pinyin = "mang " Case -15448 To -15437: pinyin = "mao " Case -15436 To -15436: pinyin = "me " Case -15435 To -15420: pinyin = "mei " Case -15419 To -15417: pinyin = "men " Case -15416 To -15409: pinyin = "meng " Case -15408 To -15395: pinyin = "mi " Case -15394 To -15386: pinyin = "mian " Case -15385 To -15378: pinyin = "miao " Case -15377 To -15376: pinyin = "mie " Case -15375 To -15370: pinyin = "min " Case -15369 To -15364: pinyin = "ming " Case -15363 To -15363: pinyin = "miu " Case -15362 To -15184: pinyin = "mo " Case -15183 To -15181: pinyin = "mou " Case -15180 To -15166: pinyin = "mu " Case -15165 To -15159: pinyin = "na " Case -15158 To -15154: pinyin = "nai " Case -15153 To -15151: pinyin = "nan "Case -15149 To -15145: pinyin = "nao " Case -15144 To -15144: pinyin = "ne " Case -15143 To -15142: pinyin = "nei " Case -15141 To -15141: pinyin = "nen " Case -15140 To -15140: pinyin = "neng " Case -15139 To -15129: pinyin = "ni " Case -15128 To -15122: pinyin = "nian " Case -15121 To -15120: pinyin = "niang " Case -15119 To -15118: pinyin = "niao " Case -15117 To -15111: pinyin = "nie " Case -15110 To -15110: pinyin = "nin " Case -15109 To -14942: pinyin = "ning " Case -14941 To -14938: pinyin = "niu " Case -14937 To -14934: pinyin = "nong " Case -14933 To -14931: pinyin = "nu " Case -14930 To -14930: pinyin = "nv " Case -14929 To -14929: pinyin = "nuan " Case -14928 To -14927: pinyin = "nue " Case -14926 To -14923: pinyin = "nuo " Case -14922 To -14922: pinyin = "o " Case -14921 To -14915: pinyin = "ou " Case -14914 To -14909: pinyin = "pa " Case -14908 To -14903: pinyin = "pai " Case -14902 To -14895: pinyin = "pan " Case -14894 To -14890: pinyin = "pang " Case -14889 To -14883: pinyin = "pao " Case -14882 To -14874: pinyin = "pei " Case -14873 To -14872: pinyin = "pen " Case -14871 To -14858: pinyin = "peng "Case -14857 To -14679: pinyin = "pi " Case -14678 To -14675: pinyin = "pian " Case -14674 To -14671: pinyin = "piao " Case -14670 To -14669: pinyin = "pie " Case -14668 To -14664: pinyin = "pin " Case -14663 To -14655: pinyin = "ping " Case -14654 To -14646: pinyin = "po " Case -14645 To -14631: pinyin = "pu " Case -14630 To -14595: pinyin = "qi " Case -14594 To -14430: pinyin = "qia " Case -14429 To -14408: pinyin = "qian " Case -14407 To -14400: pinyin = "qiang " Case -14399 To -14385: pinyin = "qiao " Case -14384 To -14380: pinyin = "qie " Case -14379 To -14369: pinyin = "qin " Case -14368 To -14356: pinyin = "qing " Case -14355 To -14354: pinyin = "qiong " Case -14353 To -14346: pinyin = "qiu " Case -14345 To -14171: pinyin = "qu " Case -14170 To -14160: pinyin = "quan " Case -14159 To -14152: pinyin = "que " Case -14151 To -14150: pinyin = "qun " Case -14149 To -14146: pinyin = "ran " Case -14145 To -14141: pinyin = "rang " Case -14140 To -14138: pinyin = "rao " Case -14137 To -14136: pinyin = "re " Case -14135 To -14126: pinyin = "ren " Case -14125 To -14124: pinyin = "reng " Case -14123 To -14123: pinyin = "ri " Case -14122 To -14113: pinyin = "rong "Case -14112 To -14110: pinyin = "rou " Case -14109 To -14100: pinyin = "ru " Case -14099 To -14098: pinyin = "ruan " Case -14097 To -14095: pinyin = "rui " Case -14094 To -14093: pinyin = "run " Case -14092 To -14091: pinyin = "ruo " Case -14090 To -14088: pinyin = "sa " Case -14087 To -14084: pinyin = "sai " Case -14083 To -13918: pinyin = "san " Case -13917 To -13915: pinyin = "sang " Case -13914 To -13911: pinyin = "sao " Case -13910 To -13908: pinyin = "se " Case -13907 To -13907: pinyin = "sen " Case -13906 To -13906: pinyin = "seng " Case -13905 To -13897: pinyin = "sha " Case -13896 To -13895: pinyin = "shai " Case -13894 To -13879: pinyin = "shan " Case -13878 To -13871: pinyin = "shang " Case -13870 To -13860: pinyin = "shao " Case -13859 To -13848: pinyin = "she " Case -13847 To -13832: pinyin = "shen " Case -13831 To -13659: pinyin = "sheng " Case -13658 To -13612: pinyin = "shi " Case -13611 To -13602: pinyin = "shou " Case -13601 To -13407: pinyin = "shu " Case -13406 To -13405: pinyin = "shua " Case -13404 To -13401: pinyin = "shuai " Case -13400 To -13399: pinyin = "shuan " Case -13398 To -13396: pinyin = "shuang " Case -13395 To -13392: pinyin = "shui "Case -13391 To -13388: pinyin = "shun " Case -13387 To -13384: pinyin = "shuo " Case -13383 To -13368: pinyin = "si " Case -13367 To -13360: pinyin = "song " Case -13359 To -13357: pinyin = "sou " Case -13356 To -13344: pinyin = "su " Case -13343 To -13341: pinyin = "suan " Case -13340 To -13330: pinyin = "sui " Case -13329 To -13327: pinyin = "sun " Case -13326 To -13319: pinyin = "suo " Case -13318 To -13148: pinyin = "ta " Case -13147 To -13139: pinyin = "tai " Case -13138 To -13121: pinyin = "tan " Case -13120 To -13108: pinyin = "tang " Case -13107 To -13097: pinyin = "tao " Case -13096 To -13096: pinyin = "te " Case -13095 To -13092: pinyin = "teng " Case -13091 To -13077: pinyin = "ti " Case -13076 To -13069: pinyin = "tian " Case -13068 To -13064: pinyin = "tiao " Case -13063 To -13061: pinyin = "tie " Case -13060 To -12889: pinyin = "ting " Case -12888 To -12876: pinyin = "tong " Case -12875 To -12872: pinyin = "tou " Case -12871 To -12861: pinyin = "tu " Case -12860 To -12859: pinyin = "tuan " Case -12858 To -12853: pinyin = "tui " Case -12852 To -12850: pinyin = "tun " Case -12849 To -12839: pinyin = "tuo " Case -12838 To -12832: pinyin = "wa "Case -12829 To -12813: pinyin = "wan " Case -12812 To -12803: pinyin = "wang " Case -12802 To -12608: pinyin = "wei " Case -12607 To -12598: pinyin = "wen " Case -12597 To -12595: pinyin = "weng " Case -12594 To -12586: pinyin = "wo " Case -12585 To -12557: pinyin = "wu " Case -12556 To -12360: pinyin = "xi " Case -12359 To -12347: pinyin = "xia " Case -12346 To -12321: pinyin = "xian " Case -12320 To -12301: pinyin = "xiang " Case -12300 To -12121: pinyin = "xiao " Case -12120 To -12100: pinyin = "xie " Case -12099 To -12090: pinyin = "xin " Case -12089 To -12075: pinyin = "xing " Case -12074 To -12068: pinyin = "xiong " Case -12067 To -12059: pinyin = "xiu " Case -12058 To -12040: pinyin = "xu " Case -12039 To -11868: pinyin = "xuan " Case -11867 To -11862: pinyin = "xue " Case -11861 To -11848: pinyin = "xun " Case -11847 To -11832: pinyin = "ya " Case -11831 To -11799: pinyin = "yan " Case -11798 To -11782: pinyin = "yang " Case -11781 To -11605: pinyin = "yao " Case -11604 To -11590: pinyin = "ye " Case -11589 To -11537: pinyin = "yi " Case -11536 To -11359: pinyin = "yin " Case -11358 To -11341: pinyin = "ying "Case -11339 To -11325: pinyin = "yong " Case -11324 To -11304: pinyin = "you " Case -11303 To -11098: pinyin = "yu " Case -11097 To -11078: pinyin = "yuan " Case -11077 To -11068: pinyin = "yue " Case -11067 To -11056: pinyin = "yun " Case -11055 To -11053: pinyin = "za " Case -11052 To -11046: pinyin = "zai " Case -11045 To -11042: pinyin = "zan " Case -11041 To -11039: pinyin = "zang " Case -11038 To -11025: pinyin = "zao " Case -11024 To -11021: pinyin = "ze " Case -11020 To -11020: pinyin = "zei " Case -11019 To -11019: pinyin = "zen " Case -11018 To -11015: pinyin = "zeng " Case -11014 To -10839: pinyin = "zha " Case -10838 To -10833: pinyin = "zhai " Case -10832 To -10816: pinyin = "zhan " Case -10815 To -10801: pinyin = "zhang " Case -10800 To -10791: pinyin = "zhao " Case -10790 To -10781: pinyin = "zhe " Case -10780 To -10765: pinyin = "zhen " Case -10764 To -10588: pinyin = "zheng " Case -10587 To -10545: pinyin = "zhi " Case -10544 To -10534: pinyin = "zhong " Case -10533 To -10520: pinyin = "zhou " Case -10519 To -10332: pinyin = "zhu " Case -10331 To -10330: pinyin = "zhua " Case -10329 To -10329: pinyin = "zhuai "Case -10328 To -10323: pinyin = "zhuan "Case -10322 To -10316: pinyin = "zhuang "Case -10315 To -10310: pinyin = "zhui "Case -10309 To -10308: pinyin = "zhun "Case -10307 To -10297: pinyin = "zhuo "Case -10296 To -10282: pinyin = "zi "Case -10281 To -10275: pinyin = "zong "Case -10274 To -10271: pinyin = "zou "Case -10270 To -10263: pinyin = "zu "Case -10262 To -10261: pinyin = "zuan "Case -10260 To -10257: pinyin = "zui "Case -10256 To -10255: pinyin = "zun "Case -10254 To -10254: pinyin = "zuo "Case Else: pinyin = pEnd SelectEnd FunctionFunction getpy(str)For i = 1 To Len(str)getpy = getpy & pinyin(Mid(str, i, 1))Next iEnd Function汉字转拼音步骤5：代码输入完成后，直接关闭Visual Basic编辑窗口，返回Excel编辑状态;汉字转拼音步骤6：自定义函数就可以用了，如：选中A2单元格，输入公式：=getpy(A2)。
EXCEL如何自动将姓名转换为拼音？
EXCEL如何自动将姓名转换为拼音？EXCEL如何自动将姓名转换为拼音，由于EXCEL中没有汉字自动转换拼音的功能，所以要在VBA中自定义一个转换函数。
具体操作步骤第一步，要把EXCEL文档转换为 XLSM格式，启用宏。
第二步，在文件，设置，自定义功能区中勾选开发工具。
第三步，打开VBA编辑器。
第四步，插入模块。
第五步，在模块中输入如下代码：Function pinyin(p As String) As String i = Asc(p)Select Case iCase -20319 To -20318: pinyin = 'a ' Case -20317 To -20305: pinyin = 'ai ' Case -20304 To -20296: pinyin = 'an ' Case -20295 To -20293: pinyin = 'ang ' Case -20292 To -20284: pinyin = 'ao ' Case -20283 To -20266: pinyin = 'ba ' Case -20265 To -20258: pinyin = 'bai ' Case -20257 To -20243: pinyin = 'ban ' Case -20242 To -20231: pinyin = 'bang ' Case -20230 To -20052: pinyin = 'bao ' Case -20051 To -20037: pinyin = 'bei ' Case -20036 To -20033: pinyin = 'ben ' Case -20032 To -20027: pinyin = 'beng ' Case -20026 To -20003: pinyin = 'bi 'Case -20002 To -19991: pinyin = 'bian ' Case -19990 To -19987: pinyin = 'biao ' Case -19986 To -19983: pinyin = 'bie ' Case -19982 To -19977: pinyin = 'bin ' Case -19976 To -19806: pinyin = 'bing ' Case -19805 To -19785: pinyin = 'bo ' Case -19784 To -19776: pinyin = 'bu ' Case -19775 To -19775: pinyin = 'ca ' Case -19774 To -19764: pinyin = 'cai ' Case -19763 To -19757: pinyin = 'can ' Case -19756 To -19752: pinyin = 'cang ' Case -19751 To -19747: pinyin = 'cao ' Case -19746 To -19742: pinyin = 'ce ' Case -19741 To -19740: pinyin = 'ceng ' Case -19739 To -19729: pinyin = 'cha ' Case -19728 To -19726: pinyin = 'chai ' Case -19725 To -19716: pinyin = 'chan ' Case -19715 To -19541: pinyin = 'chang ' Case -19540 To -19532: pinyin = 'chao ' Case -19531 To -19526: pinyin = 'che ' Case -19525 To -19516: pinyin = 'chen ' Case -19515 To -19501: pinyin = 'cheng ' Case -19500 To -19485: pinyin = 'chi ' Case -19484 To -19480: pinyin = 'chong ' Case -19479 To -19468: pinyin = 'chou ' Case -19467 To -19290: pinyin = 'chu ' Case -19289 To -19289: pinyin = 'chuai ' Case -19288 To -19282: pinyin = 'chuan ' Case -19281 To -19276: pinyin = 'chuang ' Case -19275 To -19271: pinyin = 'chui 'Case -19270 To -19264: pinyin = 'chun ' Case -19263 To -19262: pinyin = 'chuo ' Case -19261 To -19250: pinyin = 'ci ' Case -19249 To -19244: pinyin = 'cong ' Case -19243 To -19243: pinyin = 'cou ' Case -19242 To -19239: pinyin = 'cu ' Case -19238 To -19236: pinyin = 'cuan ' Case -19235 To -19228: pinyin = 'cui ' Case -19227 To -19225: pinyin = 'cun ' Case -19224 To -19219: pinyin = 'cuo ' Case -19218 To -19213: pinyin = 'da ' Case -19212 To -19039: pinyin = 'dai ' Case -19038 To -19024: pinyin = 'dan ' Case -19023 To -19019: pinyin = 'dang ' Case -19018 To -19007: pinyin = 'dao ' Case -19006 To -19004: pinyin = 'de ' Case -19003 To -18997: pinyin = 'deng ' Case -18996 To -18978: pinyin = 'di ' Case -18977 To -18962: pinyin = 'dian ' Case -18961 To -18953: pinyin = 'diao ' Case -18952 To -18784: pinyin = 'die ' Case -18783 To -18775: pinyin = 'ding ' Case -18774 To -18774: pinyin = 'diu ' Case -18773 To -18527: pinyin = 'dong ' Case -18526 To -18519: pinyin = 'fa ' Case -18518 To -18502: pinyin = 'fan ' Case -18501 To -18491: pinyin = 'fang ' Case -18490 To -18479: pinyin = 'fei ' Case -18478 To -18464: pinyin = 'fen ' Case -18463 To -18449: pinyin = 'feng 'Case -18448 To -18448: pinyin = 'fo ' Case -18447 To -18447: pinyin = 'fou ' Case -18446 To -18240: pinyin = 'fu ' Case -18239 To -18238: pinyin = 'ga ' Case -18237 To -18232: pinyin = 'gai ' Case -18231 To -18221: pinyin = 'gan ' Case -18220 To -18212: pinyin = 'gang ' Case -18211 To -18202: pinyin = 'gao ' Case -18201 To -18185: pinyin = 'ge ' Case -18184 To -18184: pinyin = 'gei ' Case -18183 To -18182: pinyin = 'gen ' Case -18181 To -18013: pinyin = 'geng ' Case -18012 To -17998: pinyin = 'gong ' Case -17997 To -17989: pinyin = 'gou ' Case -17988 To -17971: pinyin = 'gu ' Case -17970 To -17965: pinyin = 'gua ' Case -17964 To -17962: pinyin = 'guai ' Case -17961 To -17951: pinyin = 'guan ' Case -17950 To -17948: pinyin = 'guang ' Case -17947 To -17932: pinyin = 'gui ' Case -17931 To -17929: pinyin = 'gun ' Case -17928 To -17923: pinyin = 'guo ' Case -17922 To -17760: pinyin = 'ha ' Case -17759 To -17753: pinyin = 'hai ' Case -17752 To -17734: pinyin = 'han ' Case -17733 To -17731: pinyin = 'hang ' Case -17730 To -17722: pinyin = 'hao ' Case -17721 To -17704: pinyin = 'he ' Case -17703 To -17702: pinyin = 'hei ' Case -17701 To -17698: pinyin = 'hen 'Case -17697 To -17693: pinyin = 'heng ' Case -17692 To -17684: pinyin = 'hong ' Case -17683 To -17677: pinyin = 'hou ' Case -17676 To -17497: pinyin = 'hu ' Case -17496 To -17488: pinyin = 'hua ' Case -17487 To -17483: pinyin = 'huai ' Case -17482 To -17469: pinyin = 'huan ' Case -17468 To -17455: pinyin = 'huang ' Case -17454 To -17434: pinyin = 'hui ' Case -17433 To -17428: pinyin = 'hun ' Case -17427 To -17418: pinyin = 'huo ' Case -17417 To -17203: pinyin = 'ji ' Case -17202 To -17186: pinyin = 'jia ' Case -17185 To -16984: pinyin = 'jian ' Case -16983 To -16971: pinyin = 'jiang ' Case -16970 To -16943: pinyin = 'jiao ' Case -16942 To -16916: pinyin = 'jie ' Case -16915 To -16734: pinyin = 'jin ' Case -16733 To -16709: pinyin = 'jing ' Case -16708 To -16707: pinyin = 'jiong ' Case -16706 To -16690: pinyin = 'jiu ' Case -16689 To -16665: pinyin = 'ju ' Case -16664 To -16658: pinyin = 'juan ' Case -16657 To -16648: pinyin = 'jue ' Case -16647 To -16475: pinyin = 'jun ' Case -16474 To -16471: pinyin = 'ka ' Case -16470 To -16466: pinyin = 'kai ' Case -16465 To -16460: pinyin = 'kan ' Case -16459 To -16453: pinyin = 'kang ' Case -16452 To -16449: pinyin = 'kao 'Case -16448 To -16434: pinyin = 'ke ' Case -16433 To -16430: pinyin = 'ken ' Case -16429 To -16428: pinyin = 'keng ' Case -16427 To -16424: pinyin = 'kong ' Case -16423 To -16420: pinyin = 'kou ' Case -16419 To -16413: pinyin = 'ku ' Case -16412 To -16408: pinyin = 'kua ' Case -16407 To -16404: pinyin = 'kuai ' Case -16403 To -16402: pinyin = 'kuan ' Case -16401 To -16394: pinyin = 'kuang ' Case -16393 To -16221: pinyin = 'kui ' Case -16220 To -16217: pinyin = 'kun ' Case -16216 To -16213: pinyin = 'kuo ' Case -16212 To -16206: pinyin = 'la ' Case -16205 To -16203: pinyin = 'lai ' Case -16202 To -16188: pinyin = 'lan ' Case -16187 To -16181: pinyin = 'lang ' Case -16180 To -16172: pinyin = 'lao ' Case -16171 To -16170: pinyin = 'le ' Case -16169 To -16159: pinyin = 'lei ' Case -16158 To -16156: pinyin = 'leng ' Case -16155 To -15960: pinyin = 'li ' Case -15959 To -15959: pinyin = 'lia ' Case -15958 To -15945: pinyin = 'lian ' Case -15944 To -15934: pinyin = 'liang ' Case -15933 To -15921: pinyin = 'liao ' Case -15920 To -15916: pinyin = 'lie ' Case -15915 To -15904: pinyin = 'lin ' Case -15903 To -15890: pinyin = 'ling ' Case -15889 To -15879: pinyin = 'liu 'Case -15707 To -15702: pinyin = 'lou ' Case -15701 To -15682: pinyin = 'lu ' Case -15681 To -15668: pinyin = 'lv ' Case -15667 To -15662: pinyin = 'luan ' Case -15661 To -15660: pinyin = 'lue ' Case -15659 To -15653: pinyin = 'lun ' Case -15652 To -15641: pinyin = 'luo ' Case -15640 To -15632: pinyin = 'ma ' Case -15631 To -15626: pinyin = 'mai ' Case -15625 To -15455: pinyin = 'man ' Case -15454 To -15449: pinyin = 'mang ' Case -15448 To -15437: pinyin = 'mao ' Case -15436 To -15436: pinyin = 'me ' Case -15435 To -15420: pinyin = 'mei ' Case -15419 To -15417: pinyin = 'men ' Case -15416 To -15409: pinyin = 'meng ' Case -15408 To -15395: pinyin = 'mi ' Case -15394 To -15386: pinyin = 'mian ' Case -15385 To -15378: pinyin = 'miao ' Case -15377 To -15376: pinyin = 'mie ' Case -15375 To -15370: pinyin = 'min ' Case -15369 To -15364: pinyin = 'ming ' Case -15363 To -15363: pinyin = 'miu ' Case -15362 To -15184: pinyin = 'mo ' Case -15183 To -15181: pinyin = 'mou ' Case -15180 To -15166: pinyin = 'mu ' Case -15165 To -15159: pinyin = 'na ' Case -15158 To -15154: pinyin = 'nai ' Case -15153 To -15151: pinyin = 'nan 'Case -15149 To -15145: pinyin = 'nao ' Case -15144 To -15144: pinyin = 'ne ' Case -15143 To -15142: pinyin = 'nei ' Case -15141 To -15141: pinyin = 'nen ' Case -15140 To -15140: pinyin = 'neng ' Case -15139 To -15129: pinyin = 'ni ' Case -15128 To -15122: pinyin = 'nian ' Case -15121 To -15120: pinyin = 'niang ' Case -15119 To -15118: pinyin = 'niao ' Case -15117 To -15111: pinyin = 'nie ' Case -15110 To -15110: pinyin = 'nin ' Case -15109 To -14942: pinyin = 'ning ' Case -14941 To -14938: pinyin = 'niu ' Case -14937 To -14934: pinyin = 'nong ' Case -14933 To -14931: pinyin = 'nu ' Case -14930 To -14930: pinyin = 'nv ' Case -14929 To -14929: pinyin = 'nuan ' Case -14928 To -14927: pinyin = 'nue ' Case -14926 To -14923: pinyin = 'nuo ' Case -14922 To -14922: pinyin = 'o ' Case -14921 To -14915: pinyin = 'ou ' Case -14914 To -14909: pinyin = 'pa ' Case -14908 To -14903: pinyin = 'pai ' Case -14902 To -14895: pinyin = 'pan ' Case -14894 To -14890: pinyin = 'pang ' Case -14889 To -14883: pinyin = 'pao ' Case -14882 To -14874: pinyin = 'pei ' Case -14873 To -14872: pinyin = 'pen ' Case -14871 To -14858: pinyin = 'peng 'Case -14857 To -14679: pinyin = 'pi ' Case -14678 To -14675: pinyin = 'pian ' Case -14674 To -14671: pinyin = 'piao ' Case -14670 To -14669: pinyin = 'pie ' Case -14668 To -14664: pinyin = 'pin ' Case -14663 To -14655: pinyin = 'ping ' Case -14654 To -14646: pinyin = 'po ' Case -14645 To -14631: pinyin = 'pu ' Case -14630 To -14595: pinyin = 'qi ' Case -14594 To -14430: pinyin = 'qia ' Case -14429 To -14408: pinyin = 'qian ' Case -14407 To -14400: pinyin = 'qiang ' Case -14399 To -14385: pinyin = 'qiao ' Case -14384 To -14380: pinyin = 'qie ' Case -14379 To -14369: pinyin = 'qin ' Case -14368 To -14356: pinyin = 'qing ' Case -14355 To -14354: pinyin = 'qiong ' Case -14353 To -14346: pinyin = 'qiu ' Case -14345 To -14171: pinyin = 'qu ' Case -14170 To -14160: pinyin = 'quan ' Case -14159 To -14152: pinyin = 'que ' Case -14151 To -14150: pinyin = 'qun ' Case -14149 To -14146: pinyin = 'ran ' Case -14145 To -14141: pinyin = 'rang ' Case -14140 To -14138: pinyin = 'rao ' Case -14137 To -14136: pinyin = 're ' Case -14135 To -14126: pinyin = 'ren ' Case -14125 To -14124: pinyin = 'reng ' Case -14123 To -14123: pinyin = 'ri ' Case -14122 To -14113: pinyin = 'rong 'Case -14112 To -14110: pinyin = 'rou ' Case -14109 To -14100: pinyin = 'ru ' Case -14099 To -14098: pinyin = 'ruan ' Case -14097 To -14095: pinyin = 'rui ' Case -14094 To -14093: pinyin = 'run ' Case -14092 To -14091: pinyin = 'ruo ' Case -14090 To -14088: pinyin = 'sa ' Case -14087 To -14084: pinyin = 'sai ' Case -14083 To -13918: pinyin = 'san ' Case -13917 To -13915: pinyin = 'sang ' Case -13914 To -13911: pinyin = 'sao ' Case -13910 To -13908: pinyin = 'se ' Case -13907 To -13907: pinyin = 'sen ' Case -13906 To -13906: pinyin = 'seng ' Case -13905 To -13897: pinyin = 'sha ' Case -13896 To -13895: pinyin = 'shai ' Case -13894 To -13879: pinyin = 'shan ' Case -13878 To -13871: pinyin = 'shang ' Case -13870 To -13860: pinyin = 'shao ' Case -13859 To -13848: pinyin = 'she ' Case -13847 To -13832: pinyin = 'shen ' Case -13831 To -13659: pinyin = 'sheng ' Case -13658 To -13612: pinyin = 'shi ' Case -13611 To -13602: pinyin = 'shou ' Case -13601 To -13407: pinyin = 'shu ' Case -13406 To -13405: pinyin = 'shua ' Case -13404 To -13401: pinyin = 'shuai ' Case -13400 To -13399: pinyin = 'shuan ' Case -13398 To -13396: pinyin = 'shuang ' Case -13395 To -13392: pinyin = 'shui 'Case -13391 To -13388: pinyin = 'shun ' Case -13387 To -13384: pinyin = 'shuo ' Case -13383 To -13368: pinyin = 'si ' Case -13367 To -13360: pinyin = 'song ' Case -13359 To -13357: pinyin = 'sou ' Case -13356 To -13344: pinyin = 'su ' Case -13343 To -13341: pinyin = 'suan ' Case -13340 To -13330: pinyin = 'sui ' Case -13329 To -13327: pinyin = 'sun ' Case -13326 To -13319: pinyin = 'suo ' Case -13318 To -13148: pinyin = 'ta ' Case -13147 To -13139: pinyin = 'tai ' Case -13138 To -13121: pinyin = 'tan ' Case -13120 To -13108: pinyin = 'tang ' Case -13107 To -13097: pinyin = 'tao ' Case -13096 To -13096: pinyin = 'te ' Case -13095 To -13092: pinyin = 'teng ' Case -13091 To -13077: pinyin = 'ti ' Case -13076 To -13069: pinyin = 'tian ' Case -13068 To -13064: pinyin = 'tiao ' Case -13063 To -13061: pinyin = 'tie ' Case -13060 To -12889: pinyin = 'ting ' Case -12888 To -12876: pinyin = 'tong ' Case -12875 To -12872: pinyin = 'tou ' Case -12871 To -12861: pinyin = 'tu ' Case -12860 To -12859: pinyin = 'tuan ' Case -12858 To -12853: pinyin = 'tui ' Case -12852 To -12850: pinyin = 'tun ' Case -12849 To -12839: pinyin = 'tuo ' Case -12838 To -12832: pinyin = 'wa 'Case -12829 To -12813: pinyin = 'wan ' Case -12812 To -12803: pinyin = 'wang ' Case -12802 To -12608: pinyin = 'wei ' Case -12607 To -12598: pinyin = 'wen ' Case -12597 To -12595: pinyin = 'weng ' Case -12594 To -12586: pinyin = 'wo ' Case -12585 To -12557: pinyin = 'wu ' Case -12556 To -12360: pinyin = 'xi ' Case -12359 To -12347: pinyin = 'xia ' Case -12346 To -12321: pinyin = 'xian ' Case -12320 To -12301: pinyin = 'xiang ' Case -12300 To -12121: pinyin = 'xiao ' Case -12120 To -12100: pinyin = 'xie ' Case -12099 To -12090: pinyin = 'xin ' Case -12089 To -12075: pinyin = 'xing ' Case -12074 To -12068: pinyin = 'xiong ' Case -12067 To -12059: pinyin = 'xiu ' Case -12058 To -12040: pinyin = 'xu ' Case -12039 To -11868: pinyin = 'xuan ' Case -11867 To -11862: pinyin = 'xue ' Case -11861 To -11848: pinyin = 'xun ' Case -11847 To -11832: pinyin = 'ya ' Case -11831 To -11799: pinyin = 'yan ' Case -11798 To -11782: pinyin = 'yang ' Case -11781 To -11605: pinyin = 'yao ' Case -11604 To -11590: pinyin = 'ye ' Case -11589 To -11537: pinyin = 'yi ' Case -11536 To -11359: pinyin = 'yin ' Case -11358 To -11341: pinyin = 'ying 'Case -11339 To -11325: pinyin = 'yong ' Case -11324 To -11304: pinyin = 'you ' Case -11303 To -11098: pinyin = 'yu ' Case -11097 To -11078: pinyin = 'yuan ' Case -11077 To -11068: pinyin = 'yue ' Case -11067 To -11056: pinyin = 'yun ' Case -11055 To -11053: pinyin = 'za ' Case -11052 To -11046: pinyin = 'zai ' Case -11045 To -11042: pinyin = 'zan ' Case -11041 To -11039: pinyin = 'zang ' Case -11038 To -11025: pinyin = 'zao ' Case -11024 To -11021: pinyin = 'ze ' Case -11020 To -11020: pinyin = 'zei ' Case -11019 To -11019: pinyin = 'zen ' Case -11018 To -11015: pinyin = 'zeng ' Case -11014 To -10839: pinyin = 'zha ' Case -10838 To -10833: pinyin = 'zhai ' Case -10832 To -10816: pinyin = 'zhan ' Case -10815 To -10801: pinyin = 'zhang ' Case -10800 To -10791: pinyin = 'zhao ' Case -10790 To -10781: pinyin = 'zhe ' Case -10780 To -10765: pinyin = 'zhen ' Case -10764 To -10588: pinyin = 'zheng ' Case -10587 To -10545: pinyin = 'zhi ' Case -10544 To -10534: pinyin = 'zhong ' Case -10533 To -10520: pinyin = 'zhou ' Case -10519 To -10332: pinyin = 'zhu ' Case -10331 To -10330: pinyin = 'zhua ' Case -10329 To -10329: pinyin = 'zhuai 'Case -10328 To -10323: pinyin = 'zhuan ' Case -10322 To -10316: pinyin = 'zhuang ' Case -10315 To -10310: pinyin = 'zhui ' Case -10309 To -10308: pinyin = 'zhun ' Case -10307 To -10297: pinyin = 'zhuo ' Case -10296 To -10282: pinyin = 'zi ' Case -10281 To -10275: pinyin = 'zong ' Case -10274 To -10271: pinyin = 'zou ' Case -10270 To -10263: pinyin = 'zu ' Case -10262 To -10261: pinyin = 'zuan ' Case -10260 To -10257: pinyin = 'zui ' Case -10256 To -10255: pinyin = 'zun ' Case -10254 To -10254: pinyin = 'zuo ' Case Else: pinyin = pEnd SelectEnd FunctionFunction getpy(str)For i = 1 To Len(str)getpy = getpy & pinyin(Mid(str, i, 1)) Next iEnd Function第六步，输入拼音转换函数。
excel表格中汉字转拼音
excel表格中汉字转拼⾳竭诚为您提供优质⽂档/双击可除excel表格中汉字转拼⾳篇⼀：exel表格汉字转换成拼⾳的⽅法excel中把汉字变成拼⾳的⽅法：例图：1.启动excel20xx（其它版本请仿照操作），打开相应的⼯作表；2.执⾏“⼯具（开发⼯具）→宏→Visualbasic编辑器”命令（或者直接按“alt+F11”组合键），进⼊Visualbasic 编辑状态；3.执⾏“插⼊→模块”命令，插⼊⼀个新模块。
再双击插⼊的模块，进⼊模块代码编辑状态；4.将代码输⼊其中；5.代码输⼊完成后，关闭Visualbasic编辑窗⼝，返回excel编辑状态；6.⾃定义函数就可以⽤了，如：选中a2单元格，输⼊公式：=pinyin(a1)，即可出现拼⾳样式。
ps、以office20xx版本为例，若找不到“开发⼯具选项”，则在按钮中找到“excel选项”-“常⽤”-“再功能区显⽰开发⼯具选项卡”-确定。
另外，宏的设置，也是在该按钮中找到“excel选项”-“信任中⼼”-“信任中⼼设置”-“宏设置”-“启⽤所有宏”-确定。
这样就没问题了。
代码如下。
Functionpinyin(hzasstring)dimpinmaasstringdimmypinmaasVariantdimtempasinteger,iasinteger,jasintegerpinma="a,20319,ai,20317,an,20304,ang,20295,ao,20292 ,"pinma=pinma&"ba,20283,bai,20265,ban,20257,bang,2024 2,bao,20230,bei,20xx1,ben,20xx6,beng,20xx2,bi,20xx6,bian,20002,biao,19990,bie,19986,bin,19982,bing ,19976,bo,19805,bu,19784,"pinma=pinma&"ca,19775,cai,19774,can,19763,cang,1975 6,cao,19751,ce,19746,ceng,19741,cha,19739,chai,19728,chan,19725,chang,19715,chao,19540,che,19531,chen,19525,cheng,19515,chi,19500,chong,19484,chou,19479, chu,19467,chuai,19289,chuan,19288,chuang,19281,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,co u,19243,cu,19242,cuan,19238,cui,19235,cun,19227,cuo ,19224," pinma=pinma&"da,19218,dai,19212,dan,19038,dang,1902 3,dao,19018,de,19006,deng,19003,di,18996,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,187 73,dou,18763,du,18756,duan,18741,dui,18735,dun,18731,duo,18722,"pinma=pinma&"e,18710,en,18697,er,18696,"pinma=pinma&"fa,18526,fan,18518,fang,18501,fei,1849 0,fen,18478,feng,18463,fo,18448,fou,18447,fu,18446,"pinma=pinma&"ga,18239,gai,18237,gan,18231,gang,182 20,gao,18211,ge,18201,gei,18184,gen,18183,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,1796 4,guan,17961,guang,17950,gui,17947,gun,17931,guo,17 928," pinma=pinma&"ha,17922,hai,17759,han,17752,hang,17733,hao,17730,he,17721,hei,17703,hen,17701,heng,17697 ,hong,17692,hou,17683,hu,17676,hua,17496,huai,17487,huan,17482,huang,17468,hui,17454,hun,17433,huo,174 27,"pinma=pinma&"ji,17417,jia,17202,jian,17185,jiang,16 983,jiao,16970,jie,16942,jin,16915,jing,16733,jiong,16708,jiu,16706,ju,16689,juan,16664,jue,16657,jun, 16647,"pinma=pinma&"ka,16474,kai,16470,kan,16465,kang,1645 9,kao,16452,ke,16448,ken,16433,keng,16429,kong,16427,kou,16423,ku,16419,kua,16412,kuai,16407,kuan,1640 3,kuang,16401,kui,16393,kun,16220,kuo,16216,"pinma=pinma&"la,16212,lai,16205,lan,16202,lang,1618 7,lao,16180,le,16171,lei,16169,leng,16158,li,16155,lia,15959,lian,15958,liang,15944,liao,15933,lie,159 20,lin,15915,ling,15903,liu,15889,long,15878,lou,15707,lu,15701,lv,15681,luan,15667,lue,15661,lun,1565 9,luo,15652,"pinma=pinma&"ma,15640,mai,15631,man,15625,mang,1545 4,mao,15448,me,15436,mei,15435,men,15419,meng,15416 ,mi,15408,mian,15394,miao,15385,mie,15377,min,15375 ,ming,15369,miu,15363,mo,15362,mou,15183,mu,15180," pinma=pinma&"na,15165,nai,15158,nan,15153,nang,1515 0,nao,15149,ne,15144,nei,15143,nen,15141,neng,15140,ni,15139,nian,15128,niang,15121,niao,15119,nie,151 17,nin,15110,ning,15109,niu,14941,nong,14937,nu,14933,nv,14930,nuan,14929,nue,14928,nuo,14926,"pinma=pinma&"o,14922,ou,14921,"pinma=pinma&"pa,14914,pai,14908,pan,14902,pang,1489 4,pao,14889,pei,14882,pen,14873,peng,14871,pi,14857,pian,14678,piao,14674,pie,14670,pin,14668,ping,146 63,po,14654,pu,14645,"pinma=pinma&"qi,14630,qia,14594,qian,14429,qiang,14 407,qiao,14399,qie,14384,qin,14379,qing,14368,qiong,14355,qiu,14353,qu,14345,quan,14170,que,14159,qun, 14151,"。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
公司要建DataBase，为了让老外们看明白，所以要吧中文店名全部转换成拼音。
5000多家，搞得头好晕，所以请教了下高手，发现了VBA的一个小技巧，分享给大家，希望大家有用哦::P具体方法如下：打开Excel->Tools->Macro(宏)->Viaual Basic编辑器点击插入->Module(模块)然后会出现一个Module1，空白栏中粘贴以下内容：Option ExplicitOption Compare TextPublic Function HZQP(expression As String, Optional delimiter As String = " ", Optional limit As Integer = -1) As String'expression' 必需的?包含要转换的字符串?'delimiter' 可选的。
用于标识分隔拼音的字符串字符。
如果忽略，则使用空格字符(" ")作为分隔符。
如果delimiter是一个长度为零的字符串，则返回仅包含一个元素，即完整的expression字符串。
'limit' 可选的。
要返回拼音字符数，–1表示返回所有的拼音字符数，1表示返回拼音首字母。
Dim STR As String, arrWord(400) As StringDim i As Integer, j As IntegerarrWord(1) = "吖a"arrWord(2) = "哎ai"arrWord(3) = "腤an"arrWord(4) = "肮ang"arrWord(5) = "凹ao"arrWord(6) = "八ba"arrWord(7) = "挀bai"arrWord(8) = "扳ban"arrWord(9) = "邦bang"arrWord(10) = "勹bao"arrWord(11) = "陂bei"arrWord(12) = "奔ben"arrWord(14) = "皀bi" arrWord(15) = "边bian" arrWord(16) = "杓biao" arrWord(17) = "憋bie" arrWord(18) = "邠bin" arrWord(19) = "仌bing" arrWord(20) = "拨bo" arrWord(21) = "峬bu" arrWord(22) = "嚓ca" arrWord(23) = "猜cai" arrWord(24) = "飡can" arrWord(25) = "仓cang" arrWord(26) = "撡cao" arrWord(27) = "冊ce" arrWord(28) = "嵾cen" arrWord(29) = "噌ceng" arrWord(30) = "*cha" arrWord(31) = "拆chai" arrWord(32) = "辿chan" arrWord(33) = "伥chang" arrWord(34) = "抄chao" arrWord(35) = "车che" arrWord(36) = "抻chen" arrWord(37) = "阷cheng" arrWord(38) = "吃chi" arrWord(39) = "充chong" arrWord(40) = "抽chou" arrWord(41) = "出chu" arrWord(42) = "搋chuai" arrWord(43) = "巛chuan" arrWord(44) = "刅chuang" arrWord(45) = "吹chui" arrWord(46) = "旾chun" arrWord(47) = "踔chuo" arrWord(48) = "呲ci" arrWord(49) = "从cong" arrWord(50) = "凑cou"arrWord(52) = "汆cuan" arrWord(53) = "崔cui" arrWord(54) = "邨cun" arrWord(55) = "搓cuo" arrWord(56) = "咑da" arrWord(57) = "呆dai" arrWord(58) = "丹dan" arrWord(59) = "当dang" arrWord(60) = "刀dao" arrWord(61) = "恴de" arrWord(62) = "灯deng" arrWord(63) = "仾di" arrWord(64) = "敁dian" arrWord(65) = "刁diao" arrWord(66) = "爹die" arrWord(67) = "丁ding" arrWord(68) = "丟diu" arrWord(69) = "东dong" arrWord(70) = "剅dou" arrWord(71) = "嘟du" arrWord(72) = "耑duan" arrWord(73) = "垖dui" arrWord(74) = "吨dun" arrWord(75) = "多duo" arrWord(76) = "妸e" arrWord(77) = "奀en" arrWord(78) = "儿er" arrWord(79) = "发fa" arrWord(80) = "帆fan" arrWord(81) = "方fang" arrWord(82) = "飞fei" arrWord(83) = "分fen" arrWord(84) = "丰feng" arrWord(85) = "仏fo" arrWord(86) = "紑fou" arrWord(87) = "夫fu" arrWord(88) = "旮ga"arrWord(90) = "干gan" arrWord(91) = "冈gang" arrWord(92) = "皋gao" arrWord(93) = "戈ge" arrWord(94) = "给gei" arrWord(95) = "根gen" arrWord(96) = "更geng" arrWord(97) = "工gong" arrWord(98) = "勾gou" arrWord(99) = "估gu" arrWord(100) = "瓜gua" arrWord(101) = "乖guai" arrWord(102) = "关guan" arrWord(103) = "光guang" arrWord(104) = "归gui" arrWord(105) = "衮gun" arrWord(106) = "呙guo" arrWord(107) = "铪ha" arrWord(108) = "嗨hai" arrWord(109) = "佄han" arrWord(110) = "夯hang" arrWord(111) = "蒿hao" arrWord(112) = "诃he" arrWord(113) = "黒hei" arrWord(114) = "拫hen" arrWord(115) = "亨heng" arrWord(116) = "叿hong" arrWord(117) = "侯hou" arrWord(118) = "乎hu" arrWord(119) = "花hua" arrWord(120) = "怀huai" arrWord(121) = "欢huan" arrWord(122) = "巟huang" arrWord(123) = "灰hui" arrWord(124) = "昏hun" arrWord(125) = "吙huo" arrWord(126) = "丌ji"arrWord(128) = "戋jian" arrWord(129) = "江jiang" arrWord(130) = "艽jiao" arrWord(131) = "阶jie" arrWord(132) = "巾jin" arrWord(133) = "坕jing" arrWord(134) = "冂jiong" arrWord(135) = "丩jiu" arrWord(136) = "凥ju" arrWord(137) = "姢juan" arrWord(138) = "噘jue" arrWord(139) = "军jun" arrWord(140) = "咔ka" arrWord(141) = "开kai" arrWord(142) = "刊kan" arrWord(143) = "忼kang" arrWord(144) = "烤kao" arrWord(145) = "匼ke" arrWord(146) = "肎ken" arrWord(147) = "劥keng" arrWord(148) = "空kong" arrWord(149) = "抠kou" arrWord(150) = "郀ku" arrWord(151) = "夸kua" arrWord(152) = "蒯kuai" arrWord(153) = "宽kuan" arrWord(154) = "匡kuang" arrWord(155) = "亏kui" arrWord(156) = "坤kun" arrWord(157) = "扩kuo" arrWord(158) = "垃la" arrWord(159) = "来lai" arrWord(160) = "兰lan" arrWord(161) = "啷lang" arrWord(162) = "捞lao" arrWord(163) = "仂le" arrWord(164) = "雷lei"arrWord(166) = "唎li" arrWord(167) = "俩lia" arrWord(168) = "嫾lian" arrWord(169) = "簗liang" arrWord(170) = "蹽liao" arrWord(171) = "咧lie" arrWord(172) = "邻lin" arrWord(173) = "伶ling" arrWord(174) = "溜liu" arrWord(175) = "囖lo" arrWord(176) = "龙long" arrWord(177) = "娄lou" arrWord(178) = "露lu" arrWord(179) = "驴lv" arrWord(180) = "孪luan" arrWord(181) = "掠lue" arrWord(182) = "抡lun" arrWord(183) = "頱luo" arrWord(184) = "妈ma" arrWord(185) = "埋mai" arrWord(186) = "颟man" arrWord(187) = "牤mang" arrWord(188) = "猫mao" arrWord(189) = "庅me" arrWord(190) = "沒mei" arrWord(191) = "椚men" arrWord(192) = "掹meng" arrWord(193) = "咪mi" arrWord(194) = "芇mian" arrWord(195) = "喵miao" arrWord(196) = "乜mie" arrWord(197) = "民min" arrWord(198) = "名ming" arrWord(199) = "谬miu" arrWord(200) = "摸mo" arrWord(201) = "哞mou" arrWord(202) = "母mu"arrWord(204) = "腉nai" arrWord(205) = "囡nan" arrWord(206) = "囔nang" arrWord(207) = "孬nao" arrWord(208) = "讷ne" arrWord(209) = "馁nei" arrWord(210) = "嫩nen" arrWord(211) = "能neng" arrWord(212) = "妮ni" arrWord(213) = "拈nian" arrWord(214) = "娘niang" arrWord(215) = "鸟niao" arrWord(216) = "捏nie" arrWord(217) = "脌nin" arrWord(218) = "宁ning" arrWord(219) = "妞niu" arrWord(220) = "农nong" arrWord(221) = "奴nu" arrWord(222) = "女nv" arrWord(223) = "疟nue" arrWord(224) = "奻nuan" arrWord(225) = "郍nuo" arrWord(226) = "噢o" arrWord(227) = "讴ou" arrWord(228) = "妑pa" arrWord(229) = "拍pai" arrWord(230) = "眅pan" arrWord(231) = "乓pang" arrWord(232) = "抛pao" arrWord(233) = "呸pei" arrWord(234) = "喷pen" arrWord(235) = "匉peng" arrWord(236) = "丕pi" arrWord(237) = "片pian" arrWord(238) = "剽piao" arrWord(239) = "氕pie" arrWord(240) = "姘pin"arrWord(242) = "钋po" arrWord(243) = "仆pu" arrWord(244) = "七qi" arrWord(245) = "掐qia" arrWord(246) = "千qian" arrWord(247) = "呛qiang" arrWord(248) = "悄qiao" arrWord(249) = "切qie" arrWord(250) = "亲qin" arrWord(251) = "靑qing" arrWord(252) = "宆qiong" arrWord(253) = "丘qiu" arrWord(254) = "区qu" arrWord(255) = "峑quan" arrWord(256) = "炔que" arrWord(257) = "夋qun" arrWord(258) = "呥ran" arrWord(259) = "穣rang" arrWord(260) = "荛rao" arrWord(261) = "惹re" arrWord(262) = "人ren" arrWord(263) = "扔reng" arrWord(264) = "日ri" arrWord(265) = "戎rong" arrWord(266) = "厹rou" arrWord(267) = "嶿ru" arrWord(268) = "堧ruan" arrWord(269) = "桵rui" arrWord(270) = "闰run" arrWord(271) = "叒ruo" arrWord(272) = "仨sa" arrWord(273) = "毢sai" arrWord(274) = "三san" arrWord(275) = "桒sang" arrWord(276) = "掻sao" arrWord(277) = "色se" arrWord(278) = "森sen"arrWord(280) = "杀sha" arrWord(281) = "筛shai" arrWord(282) = "山shan" arrWord(283) = "伤shang" arrWord(284) = "弰shao" arrWord(285) = "奢she" arrWord(286) = "申shen" arrWord(287) = "升sheng" arrWord(288) = "尸shi" arrWord(289) = "収shou" arrWord(290) = "书shu" arrWord(291) = "刷shua" arrWord(292) = "衰shuai" arrWord(293) = "闩shuan" arrWord(294) = "霜shuang" arrWord(295) = "谁shui" arrWord(296) = "吮shun" arrWord(297) = "说shuo" arrWord(298) = "厶si" arrWord(299) = "忪song" arrWord(300) = "凁sou" arrWord(301) = "苏su" arrWord(302) = "狻suan" arrWord(303) = "夊sui" arrWord(304) = "孙sun" arrWord(305) = "唆suo" arrWord(306) = "他ta" arrWord(307) = "囼tai" arrWord(308) = "坍tan" arrWord(309) = "汤tang" arrWord(310) = "仐tao" arrWord(311) = "忑te" arrWord(312) = "鼟teng" arrWord(313) = "剔ti" arrWord(314) = "天tian" arrWord(315) = "旫tiao" arrWord(316) = "贴tie"arrWord(318) = "囲tong" arrWord(319) = "偷tou" arrWord(320) = "凸tu" arrWord(321) = "湍tuan" arrWord(322) = "推tui" arrWord(323) = "吞tun" arrWord(324) = "乇tuo" arrWord(325) = "屲wa" arrWord(326) = "歪wai" arrWord(327) = "弯wan" arrWord(328) = "尩wang" arrWord(329) = "危wei" arrWord(330) = "昷wen" arrWord(331) = "翁weng" arrWord(332) = "挝wo" arrWord(333) = "乌wu" arrWord(334) = "夕xi" arrWord(335) = "呷xia" arrWord(336) = "仙xian" arrWord(337) = "乡xiang" arrWord(338) = "灱xiao" arrWord(339) = "些xie" arrWord(340) = "心xin" arrWord(341) = "兴xing" arrWord(342) = "凶xiong" arrWord(343) = "休xiu" arrWord(344) = "戌xu" arrWord(345) = "吅xuan" arrWord(346) = "疶xue" arrWord(347) = "坃xun" arrWord(348) = "丫ya" arrWord(349) = "咽yan" arrWord(350) = "殃yang" arrWord(351) = "邀yao" arrWord(352) = "椰ye" arrWord(353) = "一yi" arrWord(354) = "乚yin"arrWord(356) = "哟yo" arrWord(357) = "佣yong" arrWord(358) = "优you" arrWord(359) = "扜yu" arrWord(360) = "囦yuan" arrWord(361) = "曰yue" arrWord(362) = "蒀yun" arrWord(363) = "帀za" arrWord(364) = "災zai" arrWord(365) = "兂zan" arrWord(366) = "牂zang" arrWord(367) = "傮zao" arrWord(368) = "啫ze" arrWord(369) = "贼zei" arrWord(370) = "怎zen" arrWord(371) = "曽zeng" arrWord(372) = "吒zha" arrWord(373) = "夈zhai" arrWord(374) = "沾zhan" arrWord(375) = "张zhang" arrWord(376) = "佋zhao" arrWord(377) = "蜇zhe" arrWord(378) = "贞zhen" arrWord(379) = "凧zheng" arrWord(380) = "之zhi" arrWord(381) = "中zhong" arrWord(382) = "州zhou" arrWord(383) = "朱zhu" arrWord(384) = "抓zhua" arrWord(385) = "拽zhuai" arrWord(386) = "专zhuan" arrWord(387) = "妆zhuang" arrWord(388) = "隹zhui" arrWord(389) = "宒zhun" arrWord(390) = "卓zhuo" arrWord(391) = "仔zi" arrWord(392) = "宗zong"arrWord(394) = "租zu"arrWord(395) = "劗zuan"arrWord(396) = "厜zui"arrWord(397) = "尊zun"arrWord(398) = "昨zuo"arrWord(399) = "咗zuo"For i = 1 To Len(expression)STR = Mid(expression, i, 1)If (Asc(STR) < 0) ThenFor j = 1 To 399If Left(arrWord(j), 1) > STR ThenIf limit = -1 ThenSTR = Mid(arrWord(j - 1), 2) & delimiterElseSTR = Mid(arrWord(j - 1), 2, limit) & delimiterEnd IfExit ForEnd IfNextEnd IfHZQP = HZQP + STRNextHZQP = Left(HZQP, Len(HZQP) - Len(delimiter))End Function到上面end就粘帖完毕了，然后关掉VB编辑窗口，就回到了excel里然后在一列里输入文字，我们有3种公式可以实现方法三种用法: =hzqp(A2,"",-1) =hzqp(A2,"-",-1) =hzqp(A2," ",-1) 蒙自西路 mengzixilu meng-zi-xi-lu meng zi xi lu另外附上已经做好的模板。