中文姓名转拼音模板

合集下载

姓名转换成拼音的宏

汉字转拼音
闫晓凰安捷陈莹薛延丰郭赫冯君华李继刚厉勇峰谢小辉李津娟唐元川李玲闻宝岩郭宗昕姚志臣郑会山王铁南刘雄张安定石显坤胡纲彭光勇唐会平连书跃李会波熊伟羊朝辉李阳吕子建王长彬宁梽伟于洪康刘艳勃金占军张海远赵洋阳赵海川薛晓强苏伟征孟祥宁张天业刘伟李东张妍光杨登峰董新发白晓亮
XiaoHuang AnJie ChenYing XueYanFeng GuoHe FengJunHua LiJiGang LiYongFeng XieXiaoHui LiJinJuan TangYuanChuan LiLing WenBaoYan GuoZong YaoZhiChen ZhengHuiShan WangTieNan LiuXiong ZhangAnDing ShiXianKun HuGang PengGuangYong TangHuiPing LianShuYue LiHuiBo XiongWei YangChaoHui LiYang LvZiJian WangChangBin NingWei YuHongKang LiuYanBo JinZhanJun ZhangHaiYuan ZhaoYangYang ZhaoHaiChuan XueXiaoQiang SuWeiZheng MengXiangNing ZhangTianYe LiuWei LiDong ZhangGuang YangDengFeng DongXinFa BaiXiaoLiang
ቤተ መጻሕፍቲ ባይዱ
YangChengWei WangXiaoMing GeGang ZhaoJiangHua ZhangJun LiShiHao ZhiXueJun LiXinCheng LiuZongLi ZhangQi YuJiaJun WangXinQuan LiuHongLiang HouYong LiuZhiQing XinGang WangLei LiuLianHua ShenHao FanBoYang TangDou WangBin LiZengBin ZhangRui ZhangJiaXin SunChunXiao LiMing DongJianHong WangZong YanHongWei TianXiaoYang CuiJiaLiang LianYanFang NaShun XuXiaoHu YaoYuan LiuChao GuoXiao LuHeChuan WangHuaJie CaiYuNa ZhangXiaoQun WangYu LiuXue YangJin WangXueGang

55中文姓名转拼音模板

G3416232 00605020 761
G3416232 00602208 347
G3416232 00606187 029
G3416232 00601253 04X
L3416232 00511300 308
G3416232 00606010 725
G3416232 00601210 728
G3416232 00602268 024
3416231010113028
wangxu
34162310101ຫໍສະໝຸດ 3037mazhengyi
3416231010113041
kangruijuan
3416231010113056
luhaodong
3416231010113057
wuxujian
3416231010113059
panshuopu
3416231010113499
3416231010122482
zhangpeipei
3416231010123004
yihuini
3416231010123018
wangyating
3416231010123047
zhanghuihui
3416231010123053
wutingting
3416231010123068
xuyueyue
G3416232 00601140 424
G3416232 00601162 324
G3412272 00101024 885
小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班小学三年级 (2)班

把汉字转换成拼音

把汉字转换成拼音
录入学生资料时需要输入姓名的汉字拼音，但怎样才能把姓名转换成拼音呢？
1、先把EXCEL中的学生姓名复制，再打开WORD，然后右键“选择性粘贴”，选择“无格式文
本”后确定。

2、再全选刚才学生的姓名，点击WORD中的“格式”菜单栏，找到“中文版式”里面的“拼音指
南”，（图1），可以把其中的“字号”由“5”设置大一些，如设置为“20”等后，然后“确定”，一次转换不成，可以再次转换，要注意一次可能转换不了，要多次才行。

转换后效果，如（图2）。

3、全选所有的文字，右键选择“切换域代码”，出现如（图3）的文字，点击“编辑”菜单栏，找
到“查找（替换）”，切换到“替换”，在“查找内容”处输入：[)]*[)]（注意是半角状态下的符号。

），在“替换为”处输入：一个半角状态下的空格，然后点击下面的“高级”，在“使用通配符”打上“√”，最后点击“全部替换”。

4、接着用同样的方法，在“查找内容”处输入：EQ*[(]*[(]（注意是半角状态下的符号。

），
在“替换为”处输入：EQ ，（注意：EQ后还有一个半角状态下的空格）（图4），然后“全部替换”。

效果如（图5）,然后右键再选择“切换域代码”，剩下拼音。

5、全选所有拼音，复制后，新建一个EXCEL文档，按右键“选择性粘贴”，即可把汉字转换
成拼音。

图1 图2 图3
6、复制刚才的拼音到EXCEL 里，在EXCEL 中选择“编辑”，找到“定位”，点击“定位条件”，在里面选择“空值”后“确定”，对着其中已经选择的空格，右键“删除”，选择“下方单元格上移”后确定，即可把拼音复制到对应的姓名右边。

图4 图5 图6。

学生名字转拼音

性别入学时间
男
2014.9
男
2014.9
女
2014.9
女
2014.9
女
2014.9
女
2014.9
女
2014.9
女
2014.9
女
2014.9
男
2014.9
女
2014.9
女
2014.9
男
2014.9
男
2014.9
男
2014.9
女
2014.9
女
2014.9
女
2014.9
女
2014.9
女
2014.9
男
2014.9
女
பைடு நூலகம்
2014.9
男
2014.9
录取专业
酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理酒店管理
48
刘品
男
2014.9
酒店管理
liu pin
Liu Pin
49 丁科玮
男
2014.9
酒店管理
ding kewei
Ding Kewei
50
黄顺
男
2014.9
酒店管理
huang shun
Huang Shun

中文姓名转拼音模板

蕊
赵洪颢程若邦程若瑶孟令哲王子月孙瑶瑶魏鑫悦史佳慧董佳
赵东阳杨振泰董濡豪赵丽研杨文卓王凤双肖梦涵程欣冉王亚林付水恒李红梅杜淑鑫王天雨董茂旺彭华锐曲瑞奥邢淑鑫杨金剑胥祁恒昌刘佟雨祁吉宇姚俊豪付子硕
杨程艺
郑傲雪
杨金诺
常娅萌
中文姓名转拼音模板刘桐旭臧佳欣王文霞于瑞成刘圣翔刘朝宏王正旭鞠蕊赵洪颢程若邦程若瑶孟令哲王子月孙瑶瑶魏鑫悦史佳慧董佳赵东阳杨振泰董濡豪赵丽研杨文卓王凤双肖梦涵程欣冉王亚林付水恒李红梅杜淑鑫王天雨董茂旺彭华锐曲瑞奥邢淑鑫杨金剑胥祁恒昌刘佟雨祁吉宇姚俊豪付子硕杨程艺郑傲雪杨金诺常娅萌
中文姓名转拼音模板

姓名转换成拼音的很方便的表注意不能有空格-

方法 FangFa
DeSaFen@weimeizi.co m,
SuiDieFuSong@weimei ,
FengDeSongGong@weim ,
FangFa@ ,
欧赔 OuPei
模块 MoKuai
按时 AnShi
OuPei@,
@,@weime ,@weimeizi.co m,AnShi@ ,MoKuai@ ,OuPei@, FangFa@, FengDeSongGong@weime ,SuiDieFuSong @,DeSaFe n@,Sheng DaFei@,S hiDe@,Sh anDouGen@weimeizi.co m,ShiDianFanGuo@weim ,DeShuangFan gGe@,Shi FaDi@,Ra ngTaHe@, @,@weime ,@weimeizi.co m,@,AnSh i@,MoKua i@,OuPei @,FangFa @,FengDe SongGong@weimeizi.co m,SuiDieFuSong@weime ,DeSaFen@weim ,ShengDaFei@ ,ShiDe@w ,ShanDouG en@,ShiD ianFanGuo@weimeizi.c om,DeShuangFangGe@we ,ShiFaDi@w ,RangTaHe @,
RangTaHe@weimeizi.co m, ShiFaDi@ ,RangTaHe@weimeizi.c om, DeShuangFangGe@weime ,ShiFaDi@weim ,RangTaHe@we , ShiDianFanGuo@weimei ,DeShuangFangG e@weimeizi.co汉m,字Sh转iF拼a 音 Di@,Rang TaHe@, ShanDouGen@weimeizi. com,ShiDianFanGuo@we ,DeShuangF angGe@,S hiFaDi@, RangTaHe@weimeizi.co m, ShiDe@,S hanDouGen@weimeizi.c om,ShiDianFanGuo@wei ,DeShuangFa ngGe@,Sh iFaDi@,R angTaHe@ , ShengDaFei@weimeizi. com,ShiDe@weimeizi.c om,ShanDouGen@weimei ,ShiDianFanGuo @,DeShua ngFangGe@weimeizi.co m,ShiFaDi@weimeizi.c om,RangTaHe@weimeizi .com,

EXCEL中文姓名转换姓名全拼音字母的Excel宏

EXCEL中文姓名转换姓名全拼音字母的Excel宏打开Excel->工具->宏->Viaual Basic编辑器在弹出来的窗口中对着VBAproject点右键->插入->模块下面会出现一个名为"模块1"，点击在右边的空白栏中粘贴以下内容：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(13) = "崩beng" 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(51) = "粗cu" 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(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(89) = "该gai" arrWord(90) = "干gan" arrWord(91) = "冈gang"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(123) = "灰hui" arrWord(124) = "昏hun" arrWord(125) = "吙huo" arrWord(126) = "丌ji" arrWord(127) = "加jia" 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(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(165) = "塄leng" 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(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(203) = "拏na" 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(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(241) = "娉ping"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(279) = "僧seng" 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(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(317) = "厅ting" 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(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(355) = "应ying" arrWord(356) = "哟yo" arrWord(357) = "佣yong" arrWord(358) = "优you" arrWord(359) = "扜yu" arrWord(360) = "囦yuan"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(392) = "宗zong"arrWord(393) = "邹zou"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在你的excel中创建宏，输入以下内容，然后在excel中使用自定义函数=hsqp(字符表达式，"",开关参数)三种用法: =hzqp(A2,"",-1) =hzqp(A2,"-",-1) =hzqp(A2," ",-1)单词公式拼音公式我们 women women wo-men wo men=hzqp(A2,"",-1) =hzqp(A2,"-",-1) =hzqp(A2," ",-1)三种用法: =hzqp(A2,"",-1) =hzqp(A2,"-",-1) =hzqp(A2," ",-1)。

excel汉字转换成拼音简拼（只取首字母）

名字转换为‎首字母（VBA自定‎义函数）1、打开EXC‎E L2、按 ALT+F11 ，点击插入-插入模块，在右面窗口‎中粘贴下面‎代码，直接关闭窗‎口3、输入公式=hztop‎y(A1)，填充所有单‎元格4、选中所有缩‎写，复制-选择性粘贴‎-数值（因为是自定‎义函数，只有在当前‎文件中可以‎显示结果，其他电脑因‎没有公式而‎显示错误）5、使用条件格‎式，检索出含有‎汉字的单元‎格:先点中一个‎单元格（设为D5），条件格式-新建格式规‎则-使用公式确‎定要设置格‎式的单元格‎：在下面对话‎框中输入公‎式=LENB(D5)>LEN(D5)，自己设置格‎式，确定后退出‎，再把该单元‎格的格式用‎格式刷刷所‎有单元格。

有汉字的出‎现所设格式‎6、选择自定义‎排序-排序依据“单元格颜色‎”-次序“无单元格颜‎色”“在底端”-确定。

7、将汉字手动‎改写为相应‎的字母。

8、核对多音字‎。

注：以上方法只‎可以在当前‎文件夹使用‎，如何将宏保‎存，使自定义函‎数可以在所‎有文件夹中‎使用1、新建一个E‎X CEL2、按 ALT+F11 ，点击插入-插入模块，在右面窗口‎中粘贴下面‎代码，直接关闭窗‎口3、另存为-其他格式-文件名改为‎宏名称、保存类型选‎择“EXCEL‎加载宏（*,xlam）”,文件将自动‎保存在C:\Users‎\111\AppDa‎t a\Roami‎n g\Micro‎s oft\AddIn‎s文件夹。

4、打开需要工‎作的EXL‎E L，点击开始-EXCEL‎选项-加载项-转到（G）...-选中上面保‎存的宏名称‎-确定。

这样，在该电脑的‎所有EXC‎E L中，都可以直接‎使用自定义‎公式。

代码(只复制星号‎内的内容)******************************************************************************* Funct‎i on hztop‎y(hzpy As Strin‎g) As Strin‎gDim hzstr‎i ng As Strin‎g, pystr‎i ng As Strin‎gDim hzpys‎u m As Integ‎e r, hzi As Integ‎e r, hzpyh‎e x As Integ‎e rhzstr‎i ng = Trim(hzpy)hzpys‎u m = Len(Trim(hzstr‎i ng))pystr‎i ng = ""For hzi = 1 To hzpys‎u mhzpyh‎e x = "&H" + Hex(Asc(Mid(hzstr‎i ng, hzi, 1)))Selec‎t Case hzpyh‎e xCase &HB0A1‎To &HB0C4‎: pystr‎i ng = pystr‎i ng + "A"Case &HB0C5‎To &HB2C0‎: pystr‎i ng = pystr‎i ng + "B"Case &HB2C1‎To &HB4ED‎: pystr‎i ng = pystr‎i ng + "C"Case &HB4EE‎To &HB6E9‎: pystr‎i ng = pystr‎i ng + "D"Case &HB6EA‎To &HB7A1‎: pystr‎i ng = pystr‎i ng + "E"Case &HB7A2‎To &HB8C0‎: pystr‎i ng = pystr‎i ng + "F"Case &HB8C1‎To &HB9FD‎: pystr‎i ng = pystr‎i ng + "G"Case &HB9FE‎To &HBBF6‎: pystr‎i ng = pystr‎i ng + "H"Case &HBBF7‎To &HBFA5‎: pystr‎i ng = pystr‎i ng + "J"Case &HBFA6‎To &HC0AB‎: pystr‎i ng = pystr‎i ng + "K"Case &HC0AC‎To &HC2E7‎: pystr‎i ng = pystr‎i ng + "L"Case &HC2E8‎To &HC4C2‎: pystr‎i ng = pystr‎i ng + "M"Case &HC4C3‎To &HC5B5‎: pystr‎i ng = pystr‎i ng + "N"Case &HC5B6‎To &HC5BD‎: pystr‎i ng = pystr‎i ng + "O"Case &HC5BE‎To &HC6D9‎: pystr‎i ng = pystr‎i ng + "P"Case &HC6DA‎To &HC8BA‎: pystr‎i ng = pystr‎i ng + "Q"Case &HC8BB‎To &HC8F5‎: pystr‎i ng = pystr‎i ng + "R"Case &HC8F6‎To &HCBF9‎: pystr‎i ng = pystr‎i ng + "S"Case &HCBFA‎To &HCDD9‎: pystr‎i ng = pystr‎i ng + "T"Case &HEDC5‎: pystr‎i ng = pystr‎i ng + "T"Case &HCDDA‎To &HCEF3‎: pystr‎i ng = pystr‎i ng + "W"Case &HCEF4‎To &HD1B8‎: pystr‎i ng = pystr‎i ng + "X"Case &HD1B9‎To &HD4D0‎: pystr‎i ng = pystr‎i ng + "Y"Case &HD4D1‎To &HD7F9‎: pystr‎i ng = pystr‎i ng + "Z"Case Elsep ystr‎i ng = pystr‎i ng + Mid(hzstr‎i ng, hzi, 1)End Selec‎tNexthztop‎y = pystr‎i ngEnd Funct‎i on*******************************************************************************。

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

拼音
chengruiqi mahaoze caozhenshan fushihan wanwenda lixiangrui yangwen guanyuyan mayubo zangzhixuan wanjinqing chengjianzheng xufuxing chenzhida chenjiarui furui qimengjie yangjiajing wangJunhong liuzhixuan zhengyushu xingyumin hanqinghuan xingmengyao weijiaqi zangqinglei liyubo yudongqing wangxinyu chenxinru zhengjiaxin gonghaolin yangwenze wangzhen wangwenhao #N/A
LTX ZJX WWX YRC LSX LCH WZX JR ZHH CRB CRY MLZ WZY SYY WXY SJH DJ ZDY YZT DRH ZLY YWZ WFS XMH CXR WYL FSH LHM DSX WTY DMW PHR QRA XSX YJJ XQHC LTY QJY YJH FZS
姓名
助记码
拼音
刘桐旭臧佳欣王文霞于瑞成刘圣翔刘朝宏王正旭鞠蕊赵洪颢程若邦程若瑶孟令哲王子月孙瑶瑶魏鑫悦史佳慧董佳赵东阳杨振泰董濡豪赵丽研杨文卓王凤双肖梦涵程欣冉王亚林付水恒李红梅杜淑鑫王天雨董茂旺彭华锐曲瑞奥邢淑鑫杨金剑胥祁恒昌刘佟雨祁吉宇姚俊豪付子硕
liutongxu zangjiaxin wangwenxia yuruicheng liushengxiang liuchaohong wangzhengxu jurui zhaohonghao chengruobang chengruoyao menglingzhe wangziyue sunyaoyao weixinyue shijiahui dongjia zhaodongyang yangzhentai dongruhao zhaoliyan yangwenzhuo wangfengshuang xiaomenghan chengxinran wangyalin fushuiheng lihongmei dushuxin wangtianyu dongmaowang penghuarui quruiao xingshuxin yangjinjian xuqihengchang liutongyu qijiyu yaoJunhao fuzishuo
许道林杨程艺郑傲雪杨金诺常娅萌
XDL YCY ZAX YJN CYM
xudaolin yangchengyi zhengaoxue yangjinnuo changyameng
姓名
程瑞琪马昊泽曹振山付诗涵万文达李祥瑞杨文关玉研马裕博臧志轩万金卿程建政胥福星陈志达陈嘉睿付瑞齐梦洁杨佳静王俊宏刘志轩郑煜树邢玉民韩庆焕邢梦瑶魏佳琪臧清雷栗玉博于冬青王新宇陈心如郑嘉馨龚浩林杨文泽王祯王文豪杨朝涵

助记码
CRQ MHZ CZS FSH WWD LXR YW GYY MYB ZZX WJQ CJZ XFX CZD CJR FR QMJ YJJ WJH LZX ZYS XYM HQH XMY WJQ ZQL LYB YDQ WXY CXR ZJX GHL YWZ WZ WWH YCH