把汉字转换成拼音
汉字转拼音,excel汉字转拼音的方法及步骤【修复无错版】
汉字转拼音,excel汉字转拼音的方法及步骤【修复无错版】店铺为大家带来修复无错版的excel汉字转拼音的方法及步骤，其他网站所提供的代码大部分有错误，修复了d和e为首字母的拼音读取，欢迎大家参考。
excel汉字转拼音的方法及步骤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 -18764: pinyin ="dong" Case -18763 To -18757: pinyin ="dou" Case -18756 To -18742: pinyin ="du" Case -18741 To -18736: pinyin ="duan" Case -18735 To -18732: pinyin ="dui" Case -18731 To -18723: pinyin ="dun" Case -18722 To -18711: pinyin ="duo" Case -18710 To -18698: pinyin ="e" Case -18697 To -18697: pinyin ="en" Case -18696 To -18527: pinyin ="er" 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 -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 -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 -15878 To -15708: pinyin ="long" 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 -15158 To -15154: pinyin ="nai" Case -15153 To -15151: pinyin ="nan" Case -15150 To -15150: pinyin ="nang" 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 -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 -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 -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 ="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 -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 ="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 -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 -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 Else: pinyin = pEnd SelectEnd FunctionFunction getpy(str)For i = 1 To Len(str)getpy = getpy & pinyin(Mid(str, i, 1))Next iEnd Function5.代码输入完成后，直接关闭Visual Basic编辑窗口，返回Excel 编辑状态;6.自定义函数就可以用了，如：选中A2单元格，输入公式：=getpy(A2)。
excel中把汉字转换成拼音的方法
excel中把汉字转换成拼音的方法在excel中把的汉字转换成拼音，拼音在字的上面，在word和EXCEL中，都可以，再粘贴到别的地方，用起来不如word，那么下面小编就教你具体怎么怎么把汉字转换成拼音吧。
希望对你有帮助！excel中把汉字转换成拼音的方法打开需要转换的excel表格单击excel表格的任意位置，然后按下ALT+F11，进入这个灰色的编辑界面excel中把汉字转换成拼音的方法图2插入--模块excel中把汉字转换成拼音的方法图3打开如下所示的界面。
excel中把汉字转换成拼音的方法图4把下面的内容复制粘贴到第四个步骤打开的界面中，并保存，参考下图操作。
Function pinyin(p As String) As Stringi = Asc(p)Select Case iCase -20319 To -20318: pinyin = "a "Case Else: pinyin = pEnd SelectEnd FunctionFunction getpy(str)For i = 1 To Len(str)getpy = getpy & pinyin(Mid(str, i, 1))Next iEnd Functionexcel中把汉字转换成拼音的方法图5保存，参考图片进行操作。
excel中把汉字转换成拼音的方法图6插入一列，用于存放转换后的拼音excel中把汉字转换成拼音的方法图7这里放在如果所示的这一列，在这一列中输入=getpy(转换源头所在的列)excel中把汉字转换成拼音的方法图8这是转成拼音后的效果excel中把汉字转换成拼音的方法图9这里的D2是数据源头excel中把汉字转换成拼音的方法图10。
在Word中将文字转换成拼音
在Word中将文字转换成拼音
如果想把整篇文章转换成拼音字母而且还需要在转换成拼音字母后仍保留
原文中的数字、英语字母、标点符号、段落等内容，可以用下面的方法来实现。
（例文：“转换成为拼音”）
1、选中需要转换的文本，用“拼音指南”给文本标注上拼音（如下图）。
2、选中标注好拼音的全部文字，右击选择“切换域代码”，选中内容会变成下图的样子。
3、“菜单--编辑--替换”
打开替换窗口，在“查找
内容”中输入半角的
“[)]*[)]”，“替换为”中
输入一个半角的空格。
点
击“高级搜索”按钮显示高
级选项，点选“使用通配
符”（如右图）。
点击“全部替换”按
钮，然后一直确定完成替
换。
4、再输入查找内容为
“EQ*[(]*[(]”，“替换为”
中输入“EQ ”（注意：EQ
后面有一个半角的空
格），（如右图）。
点击
“全部替换”按钮完成替
换，之后关闭替换窗口。
5、选中替换后的文本进行“剪切”，再“选择性粘贴”为“匹配当前格式”（如果不行则粘贴为“无格式文本”）即可看到文中需要转换的汉字部分都已经变成拼音字母，而且原文中的数字、英语字母、标点符号、段落等内容也还在。
excel2010汉字转拼音的方法步骤
excel2010汉字转拼音的方法步骤在Excel中录入好数据以后可能会有需要把汉字转拼音的需求，或许有的朋友并不知道该如何汉字转拼音，如果不懂的朋友欢迎一起来探究学习。
下面是店铺带来的关于excel2010汉字转拼音的方法，希望阅读过后对你有所启发!excel2010汉字转拼音的方法1汉字转拼音步骤1：打开你的Excel文件，按“Alt+F11”打开VBA编辑窗口，然后在左侧空白处点击右键，“插入”，“模块”。
右侧空白处粘贴下面的代码。
关闭VBA窗口。
汉字转拼音步骤2：代码太长，超字数限制了，请从这里下载：/s/1bnCn9fD汉字转拼音步骤3：然后在需要的地方输入公式：=PINYIN(单元格地址) 即可。
汉字转拼音步骤4：如下图，在B1输入：=PINYIN(A1)excel2010汉字转拼音的方法2汉字转拼音步骤1：启动Excel 2010(其它版本请仿照操作)，打开相应的工作表;汉字转拼音步骤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 -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 -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 -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 -15878 To -15708: pinyin = "long " 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 -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 -15150 To -15150: pinyin = "nang " 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 -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 = "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 -11340 To -11340: pinyin = "yo " 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表格中汉字转拼⾳篇⼀：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.确定拼音字母对应表：
将汉字的发音转换为相应的拼音字母是关键，可以使用如下的拼音字母对应表：
a喀嚓啪呱
o哦吧啊噢
e饿恶扼遏呃嗯
i衣衣依衣
u乌污兀呜
ü温安抠呜
ai 艾才哀埃挨唉哎皑癌蔼矮
ei 诶蔺恶欸诶哎
ao 奥澳傲坳袄岙骯
ou 欧偶呕鸥殴藕沤讴瓯区
ia 呀丫
ie 也些爷耶倻掖椰
ua 挖
uo 挝
üe学
ün困
iu 宿溺坞
ve 了
er 尔耳饵洱贰二而儿
an 安黯桉氨鞍俺铵盦
en 恩摁蒽
ang 昂盎肮骯
eng 恩鞥
ong 雍踊俑佣勇臃痈拥永涌泳恿用咏喁
2.汉字转拼音的规则：
-单个汉字：根据发音转换为对应的拼音字母。
如果有多个发音，则选择常用的一个。
-词组和句子：将每个汉字按照单个汉字的规则转换为拼音，然后组合在一起。
例如，将汉字"中文转为拼音的公式"转换为拼音可以按照以下步骤进行：
1.将每个汉字转换为对应的拼音字母：
2.将每个拼音字母组合在一起：
zhōng wén zhuǎn wéi pīn yīn de gōng shì -> zhong wen zhuan wei pin yin de gong shi
以上公式是其中一种常见的中文转拼音的方式，实际上还有其他方案和不同的规则。
每个方案都有自己的转换规则和对应关系，可以根据具体需求选择适合的方案。
汉字如何转化成拼音？
汉字如何转化成拼音？
前言
一向对车很有研究的吴同学,经常自己DIY,比如换个机油啊,清理个积碳啊等等,但是也经常问我EXCEL的问题,昨天又出了道难题给我。
如何把中文转换成拼音?
我说我研究一下吧,好像WORD有这个功能来着,吴同学好像等不及了,说还是手输吧,反正也不多,看看，动手能力强的人,就是说干就干。
活干完了,不等于问题解决了,老崔还是要研究一下的,如果中文太多了你还会用手一个个输吗?你不会输错吗?说不定下次还会用得着,不如研究到底,下次就可以坐享其成了。
话不多说,进入正题
解题思路
EXCEL中A列为汉字,要求在B列返回对应的拼音
01
首先复制A列内容到WORD中，粘贴选项选择为“只保留文本”，如下图所示：
02
选择要标注拼音的汉字，在“开始”菜单，下面点击“拼音指南”。
弹出对话框，如下图所示：
不需要太多设置，直接点击确定，结果如下：
看看，拼音是不是出来了，以后有不认识的字，或者文章，可以用此方法直接转换成少儿版的了。
03
复制拼音和汉字，把其粘贴到刚才EXCEL中的C列，如下图所示：
04
那么如何获取单独的拼音呢？
讲这个之前，你是否记得讲字符连接时，好像讲过一个Phonetic 函数，此函数毛病还挺多，公式不行，数字也不行，好像只有文本才可以连接起来，具体参照下面的超链接看一下：
说来也不怪他，本身干那个就是个业余爱好，它真正的主营业务就是获取拼音的，我们试一下：
在B2中输入
=PHONETIC(C2)
下拉复制公式，结果如下：。
中文转拼音的函数
中文转拼音的函数一、概述中文转拼音是指将汉字转换为对应的拼音（英文字母），以方便国际交流和计算机处理。
在日常生活中，我们经常会使用中文拼音来搜索、输入或标注汉字，因此中文转拼音的函数非常有用，可以帮助我们快速、准确地进行这些操作。
本文将介绍如何编写一个功能完备的中文转拼音的函数，以满足各种实际需求。
二、拼音系统拼音系统是指将汉字按照一定的规则转换为对应的拼音的方法和标准。
目前常用的拼音系统有汉语拼音、注音符号、粤语拼音等。
在本文中，我们将以汉语拼音为基础，讲解如何实现中文转拼音的函数。
三、常见的中文转拼音方法中文转拼音的方法有很多种，例如：1.首字母缩写法：根据汉字的拼音首字母进行缩写，如”中国”可以转换为”ZG”；2.全拼法：将每个汉字根据发音转换为拼音字母，如”中国”可以转换为”zhong guo”；3.多音字处理：在转换过程中，对于拼音有多个读音的汉字，需要根据上下文或词组进行正确的匹配，如”重庆”的读音可以是”chong qing”或”zhong qing”；4.音调标记法：在拼音的基础上，使用数字或符号表示声调，如”zhōng guó”表示”中国”的拼音。
下面我们将以全拼法为例，介绍如何编写一个函数来实现中文转拼音。
四、Python实现中文转拼音的函数1. 安装拼音库为了方便地实现中文转拼音的功能，我们可以使用Python的拼音库，例如pypinyin库。
可以使用以下命令来安装该库：pip install pypinyin2. 导入拼音库安装完成后，我们需要在Python代码中导入该库，并进行初始化操作：import pypinyinpypinyin.load_phrases_dict()3. 编写转换函数接下来，我们可以编写一个函数来实现中文转拼音的功能：def chinese_to_pinyin(chinese_str):pinyin_list = pypinyin.pinyin(chinese_str, style=pypinyin.NORMAL) pinyin_str_list = []for pinyin in pinyin_list:pinyin_str_list.append(pinyin[0])return ' '.join(pinyin_str_list)4. 使用示例我们可以使用以下代码来测试刚刚编写的中文转拼音函数：chinese_str = "中国"pinyin = chinese_to_pinyin(chinese_str)print(pinyin) # 输出："zhong guo"五、进阶功能扩展1. 多音字处理在实际应用中，由于汉字存在多音字的情况，因此需要对多音字进行正确的匹配。
中文转为拼音的公式
将中文转为拼音的公式通常涉及到一些特定的算法和规则，这些规则将汉字转换为对应的拼音字母。
以下是一个简单的示例公式：
1. 提取汉字的声母：根据汉字的声母表，将汉字的声母部分提取出来。
2. 提取汉字的韵母：根据汉字的韵母表，将汉字的韵母部分提取出来。
3. 拼接声母和韵母：将提取出的声母和韵母拼接在一起，形成完整的拼音。
需要注意的是，这个公式只是一个简单的示例，实际的转换过程可能更加复杂，需要考虑更多的细节和规则，例如声调的处理、多音字的处理等。
因此，在实际应用中，通常需要使用专门的拼音转换工具或库来进行准确的转换。
拼音转换：将文档中的汉字转换为拼音
拼音转换：将文档中的汉字转换为拼音
本文档旨在介绍如何将文档中的汉字转换为拼音。
拼音转换可
以方便读者快速识别和发音汉字，提升阅读体验。
以下是一种简单
的方法，供参考：
1. 引入必要的库和工具
首先，你需要确保你的计算机上安装了能够进行拼音转换的库
和工具。
推荐使用Python编程语言，并安装相关的库如`pypinyin`。
2. 读取文档内容
使用适当的方法读取文档的内容，可以是通过读取文件或者从
其他来源获取文本内容。
3. 分割文档内容
对文档的内容进行分割，以便逐个处理每个汉字。
可以使用空
格或其他分隔符将文档内容拆分成单个词语。
4. 汉字转换为拼音
对每个汉字进行拼音转换。
使用`pypinyin`库的转换功能将汉字转换为对应的拼音音节，可以选择转换成带声调的拼音或者不带声调的拼音。
5. 拼音替换文档内容
将转换后的拼音替换原文档中的每个汉字。
可以使用简单的字符串替换方法，将汉字替换为拼音音节。
6. 保存转换后的文档
将转换后带拼音的文档保存到指定的位置。
可以选择覆盖原文档或者另存为新的文档。
7. 完成拼音转换
经过以上步骤，你已经成功将文档中的汉字转换为拼音。
现在可以方便地阅读和发音汉字，提高文档的可读性。
请注意，以上方法是一种简单的策略，旨在提供基本的拼音转换功能。
具体实现细节和代码可以根据你的需要进行进一步的调整和优化。
希望这份文档可以对你有所帮助！。
汉字转拼音原理
汉字转拼音原理
汉字转拼音是一个将汉字转换为对应拼音的过程。
其原理是基于汉字的发音规则和拼音系统。
汉字的发音规则是指汉字与对应读音之间的关系。
在汉字中，每个字通常由一个或多个汉字组成，每个汉字都有一个确定的发音。
这个发音可以通过字典、词典或语音库等资源获取。
拼音系统是一种用拼音标注汉字发音的方法。
其中最常用的是汉语拼音，它是一种音标系统，用拉丁字母表示汉字的发音。
汉语拼音的规则和音标是通过专门的语音学研究确定的，可以准确地表示汉字的发音。
将汉字转换为拼音的方法主要有以下几种：
1. 根据汉字的拼音规则进行转换。
这种方法是根据已有的汉字发音规则，将每个汉字转换为对应的拼音音标。
例如，根据拼音规则，汉字“中国”可以转换为“zhōng guó”。
2. 使用已有的字典或词典进行转换。
字典或词典中包含了大量的汉字及其对应的拼音，可以通过查询字典或词典来获取汉字的拼音。
例如，通过查询字典，可以将汉字“人”查询为“rén”。
3. 基于机器学习或人工智能的方法进行转换。
这种方法是通过训练模型来将汉字转换为拼音。
通过给模型输入大量的汉字和对应的拼音，让模型学习汉字和拼音之间的对应关系，从而实现自动转换。
无论采用哪种方法，汉字转拼音的目标都是将汉字的发音准确地转换为对应的拼音，以方便人们进行阅读、输入和学习汉字。
excel 表格将汉字名字转换为汉语拼音
excel 表格将汉字名字，转换为汉语拼音excel 表格将汉字名字，转换为汉语拼音，除婵、婷、妍、倩、奕、嫦、冼、钰、炜、泉、楠、佼等部分字不能转换外，大部可以用此方法转换的。
打开excel 添加个模块Function PinYin(Hz As String)Dim PinMa As StringDim MyPinMa As VariantDim Temp As Integer, i As Integer, j As IntegerPinMa = "a,20319,ai,20317,an,20304,ang,20295,ao,20292,"PinMa = PinMa &"ba,20283,bai,20265,ban,20257,bang,20242,bao,20230,bei,20051,ben,20036,beng,200 32,bi,20026,bian,20002,biao,19990,bie,19986,bin,19982,bing,19976,bo,19805,bu,19 784,"PinMa = PinMa &"ca,19775,cai,19774,can,19763,cang,19756,cao,19751,ce,19746,ceng,19741,cha,1973 9,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,1928 1,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,cou,19243,cu,19242,cuan, 19238,cui,19235,cun,19227,cuo,19224,"PinMa = PinMa &"da,19218,dai,19212,dan,19038,dang,19023,dao,19018,de,19006,deng,19003,di,18996 ,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,18773,dou,18763,du,1 8756,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,18490,fen,18478,feng,18463,fo,18448,fou,1844 7,fu,18446,"PinMa = PinMa &"ga,18239,gai,18237,gan,18231,gang,18220,gao,18211,ge,18201,gei,18184,gen,18183 ,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,17964,guan,17961,guang ,17950,gui,17947,gun,17931,guo,17928,"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,17427,"PinMa = PinMa &"ji,17417,jia,17202,jian,17185,jiang,16983,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,16459,kao,16452,ke,16448,ken,16433,keng,1642 9,kong,16427,kou,16423,ku,16419,kua,16412,kuai,16407,kuan,16403,kuang,16401,kui ,16393,kun,16220,kuo,16216,"PinMa = PinMa &"la,16212,lai,16205,lan,16202,lang,16187,lao,16180,le,16171,lei,16169,leng,1615 8,li,16155,lia,15959,lian,15958,liang,15944,liao,15933,lie,15920,lin,15915,ling ,15903,liu,15889,long,15878,lou,15707,lu,15701,lv,15681,luan,15667,lue,15661,lu n,15659,luo,15652,"PinMa = PinMa &"ma,15640,mai,15631,man,15625,mang,15454,mao,15448,me,15436,mei,15435,men,15419 ,meng,15416,mi,15408,mian,15394,miao,15385,mie,15377,min,15375,ming,15369,miu,1 5363,mo,15362,mou,15183,mu,15180,"PinMa = PinMa &"na,15165,nai,15158,nan,15153,nang,15150,nao,15149,ne,15144,nei,15143,nen,15141 ,neng,15140,ni,15139,nian,15128,niang,15121,niao,15119,nie,15117,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,14894,pao,14889,pei,14882,pen,14873,peng,148 71,pi,14857,pian,14678,piao,14674,pie,14670,pin,14668,ping,14663,po,14654,pu,14 645,"PinMa = PinMa &"qi,14630,qia,14594,qian,14429,qiang,14407,qiao,14399,qie,14384,qin,14379,qing, 14368,qiong,14355,qiu,14353,qu,14345,quan,14170,que,14159,qun,14151,"PinMa = PinMa &"ran,14149,rang,14145,rao,14140,re,14137,ren,14135,reng,14125,ri,14123,rong,141 22,rou,14112,ru,14109,ruan,14099,rui,14097,run,14094,ruo,14092,"PinMa = PinMa &"sa,14090,sai,14087,san,14083,sang,13917,sao,13914,se,13910,sen,13907,seng,1390 6,sha,13905,shai,13896,shan,13894,shang,13878,shao,13870,she,13859,shen,13847,s heng,13831,shi,13658,shou,13611,shu,13601,shua,13406,shuai,13404,shuan,13400,sh uang,13398,shui,13395,shun,13391,shuo,13387,si,13383,song,13367,sou,13359,su,13 356,suan,13343,sui,13340,sun,13329,suo,13326,"PinMa = PinMa &"ta,13318,tai,13147,tan,13138,tang,13120,tao,13107,te,13096,teng,13095,ti,13091 ,tian,13076,tiao,13068,tie,13063,ting,13060,tong,12888,tou,12875,tu,12871,tuan, 12860,tui,12858,tun,12852,tuo,12849,"PinMa = PinMa &"wa,12838,wai,12831,wan,12829,wang,12812,wei,12802,wen,12607,weng,12597,wo,1259 4,wu,12585,"PinMa = PinMa &"xi,12556,xia,12359,xian,12346,xiang,12320,xiao,12300,xie,12120,xin,12099,xing, 12089,xiong,12074,xiu,12067,xu,12058,xuan,12039,xue,11867,xun,11861,"PinMa = PinMa &"ya,11847,yan,11831,yang,11798,yao,11781,ye,11604,yi,11589,yin,11536,ying,11358 ,yo,11340,yong,11339,you,11324,yu,11303,yuan,11097,yue,11077,yun,11067," PinMa = PinMa &"za,11055,zai,11052,zan,11045,zang,11041,zao,11038,ze,11024,zei,11020,zen,11019 ,zeng,11018,zha,11014,zhai,10838,zhan,10832,zhang,10815,zhao,10800,zhe,10790,zh en,10780,zheng,10764,zhi,10587,zhong,10544,zhou,10533,zhu,10519,zhua,10331,zhua i,10329,zhuan,10328,zhuang,10322,zhui,10315,zhun,10309,zhuo,10307,zi,10296,zong ,10281,zou,10274,zu,10270,zuan,10262,zui,10260,zun,10256,zuo,10254"MyPinMa = Split(PinMa, ",")For i = 1 To Len(Hz)Temp = Asc(Mid(Hz, i, 1))If Temp < 0 ThenTemp = Abs(Temp)For j = 791 To 1 Step -2If Temp <= Val(MyPinMa(j)) ThenPinYin = PinYin & MyPinMa(j - 1) & " "Exit ForEnd IfNextEnd IfNextPinYin = Trim(PinYin)End Function以上拼音码表是从网上一些工具源文伯中获得,未全部验证其准确性,但愿不会有错吧!至于算法就是根据汉字ASC码与码表进行比对,有点难看.使用中发现上边码表所获仅限于GB2312-80 I 级汉字然后再任意单元格输入=pinyin(A1)就把A1中的汉字转换成拼音了。
Excel和Word中怎么把汉字转化为拼音【百科全说】
Excel和Word中怎么把汉字转化为拼音【百科全说】我们可以利用Excel和word软件将汉字转换成拼音，具体怎么操作呢？小编为大家解答这个问题。
具体如下：1.1. 第一步，请大家先复制A列内容到WORD里，当我们粘贴时，请点击“只保留文本”这一项。
2.2.第二步，请大家点击选择自己想标注拼音的汉字，然后点击屏幕左上方的“开始”菜单，接着选择“拼音指南”即可。
3.3. 第三步，出现了如图所示的界面。
4.4. 第四步，我们不需要设置太多，请选择【确定】即可，效果如图。
5.5. 第五步，请大家复制拼音和汉字，然后将其粘贴到刚刚EXCEL里的C列即可。
6.6. 最后，请大家在B2中输入=PHONETIC(C2)然后下拉复制公式，就会出现如图所示的结果，操作完成。
7.以上就是Excel和Word中把汉字转化为拼音的方法。
时间：2019-09-24 02:43 / 作者：百科全说WORD中如何输入汉字拼音中的一二三四声?12/09 04:33问题：WORD中如何输入汉字拼音中的一二三四声? 请详细解答说明，谢谢! 解答：选择拼音打字法，然后把光标放在拼音打字标示条最右边的键盘标志上，点右键选择拼音，然后在电脑屏幕上就会出现一个可以打拼音的键盘，在上面点击你要输入的拼音字母就可以了? excel或word中的表格无法复制到ppt中去怎么办?08/14 15:20出现这样的情况,可能存在下面的原因: 1.系统存在问题或OFFICE 软件存在问题: 2.表格过大,导至PPT一页无法全部显示. 解决办法(前题的OFFICE软件和系统软件正常.无故障) 1.重新调整表格尺寸,使之适应PPT页面: 2.在PPT软件中选择"标题和表格"版式,直接里该页面制表.3.在EXCEL或WORD中制一个小表,看是否可以复制到PPT里去.如果可以,证明OFFICE软件没问题,如果不可以你就要考虑重装或修复OFFICE了!在Word中怎么为汉字添加拼音?word汉字加拼音方法02/11 13:46为了满足制作一些特殊需要的文档,除了在word里可以输入中文和英文字符,还可以为中文添加拼音,下面我们一起来看看吧! 1.打开word软件,打开或者新建一篇文档. 2.选中要添加拼音的文字.一次可以选中多个汉字,不必一个一个的进行操作.依次点击“开始”,“拼音指南”. 3.在拼音指南”窗口,依次在表格里输入拼音,因为软件不能不会自动识别汉字导出拼音. 4.更改对齐方式为“居中”,因为上图中字母的间距太大了. 5.偏移量是指汉字与拼音之间的距离是多大,默认0就可以,按自己的要求也可以更改. 6.甚怎么在Excel或者Word中插入自己的签名11/18 21:59有的小伙伴制作了一份报价Word或者Excel文档,为了证明这是自己的报价文件,因此想要插入自己的签名,但是却不知道如何插入,那么小编就来为大家介绍一下吧.具体如下:1. 第一步,我们需要一份属于自己的PNG文件的签名,小编想要在这儿提醒一下,签名的文件一定是PNG格式的矢量图,可以在PS中制作签名.2. 第二步,双击或者右击打开需要的放置签名的文档.3. 第三步,来到下图所示的文档页面后,点击需要插入签名的位置,接着点击页面顶部的插入选项,然后点击箭头所指的图片选项. 4. 第四步,在图片窗口如何在excel或Word中画出斜的波浪线08/06 15:45在word中画出斜波浪线方法: 通过插入--文本框绘制出一个文本框,在文本框中连续按空格,选中空格,添加波浪式的下划线: 通过旋转文本框,使波浪线倾斜: 选中文本框,右键点击,选择设置形状格式,把形状填充和线条颜色都设置为无即可.Word中怎么将繁体字转化为简体字05/23 14:24在网上搜索相关技术文档或者论文材料的时候，经常会遇到一些繁体文档。
中文拼音互译
中文拼音互译
中文拼音互译是指将中文文字转换成对应的拼音，或者将拼音转换成中文文字。
这种转换方式在中文学习、输入法、语音识别等方面有着广泛的应用。
在中文学习中，中文拼音互译可以帮助学习者更好地理解和记忆汉字的发音。
通过将中文汉字转换成拼音，学习者可以更加准确地发音，避免读音错误。
同时，拼音互译也可以加深对拼音和汉字之间的对应关系的理解，有助于提高阅读和听说能力。
在输入法中，中文拼音互译是一种常见的输入方式。
用户可以通过输入汉字的拼音，输入法会自动匹配对应的汉字候选词，用户可以选择正确的汉字进行输入。
这种输入方式简化了输入过程，提高了输入效率。
在语音识别中，中文拼音互译可以将语音转换成文本。
用户可以通过朗读中文拼音，语音识别系统会将其转换成对应的汉字文本。
这种方式方便了用户进行语音输入，特别是在移动设备上。
需要注意的是，中文拼音互译的准确性对于以上应用场景非常重要。
如果转换结果出现错误，可能会导致学习者理解错误、输入错误或语音识别错误。
因此，拼音输入法和语音识别系统都需要不断改进和优化，提高准确率和用户体验。
总之，中文拼音互译在中文学习、输入法和语音识别等方面有着重要作用。
它可以帮助学习者准确发音、提高输入效率和方便语音输入。
然而，在使用中需要确保准确性和流畅性，避免出现错误或影响用户体验的问题。
中文转为拼音的公式
中文转为拼音的公式中文转拼音的公式遵循以下规则：1.音节划分规则：-单韵母音节直接作为一个音节，例如"我"的拼音为"wǒ"。
- 复韵母音节分为两个音节，例如"脚"的拼音为"jiǎo"。
- 韵母"iu"读作"iou"，例如"那时"的拼音为"nàshí"。
- 韵母"ui"读作"uei"，例如"灰"的拼音为"huī"。
- 韵母"un"读作"uen"，例如"忙"的拼音为"máng"。
- 韵母"ü"转换为"v"，例如"香"的拼音为"xiāng"。
2.声母对应表：-b=b-p=p-m=m-f=f-d=d-t=t-n=n-l=l-g=g-k=k-h=h-j=j-q=q-x=x-z=z-c=c-s=s- zh = zh- ch = ch- sh = sh-r=r-y=y-w=w3.声调标记：-第一声：ā,ē,ī,ō,ū-第二声：á,é,í,ó,ú-第三声：ǎ,ě,ǐ,ǒ,ǔ-第四声：à,è,ì,ò,ù-不标调：a,e,i,o,u4.注意事项：-在空格处发生分词后，需要在每个分词后面加上声调标记，同时遵循以上规则。
举例：- "中国"的拼音为"zhōng guó"。
- "转化"的拼音为"zhuǎn huà"。
如何使用Excel将中文名转换成拼音
方法一：自定义函数法1.创建一个Excel文件2.打开Excel，点击“文件-选项”。
如下图：3.将“开发工具”调出。
如下图：4.点击“开发工具- Visual Basic”。
如下图：5.右击插入模块，复制代码（在文末）。
如下图：6.保存时候会出来这个选项，都可以，不影响后续。
如下图：7.像普通函数一样，使用即可。
代码：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 -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 -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 -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 -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 -15878 To -15708: pinyin = "long " 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 -15150 To -15150: pinyin = "nang "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 -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 -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 -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 = "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 -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 -11340 To -11340: pinyin = "yo " 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 -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 FunctionFunction gets(str) '得到首字母gets = Left(getpy(str), 1)End FunctionFunction getqs(str) '得到全首字母For i = 1 To Len(str)getqs = getqs & Left(pinyin(Mid(str, i, 1)), 1) Next iEnd Function。
汉字转拼音公式
将汉字转换为拼音，可以使用以下两种方法：
方法一（使用Office Excel 2007）：
1. 打开一个新的Excel文档。
2. 在D2单元格中输入“=getpy(C2)”，然后按回车键确认。
3. 将鼠标放在D2单元格右下角，当出现“+”后，向下拖动鼠标。
4. 这样，姓名一栏所有的汉字都以拼音形式显示了。
5. 如果需要将拼音的首字母变成大写，可以将鼠标标定在E2单元格中，然后输入“=PROPER(D2)”，按回车键确认。
6. 重复步骤3~5，即可将所有汉字转换为拼音。
方法二（使用Word文档和拼音指南功能）：
1. 打开一个新的Word文档，并将表格中的员工姓名复制到Word文档中。
2. 按下CTRL+A，选择所有数据，确保整个文档被选中。
3. 在开始选项卡下找到拼音指南，并点击确认。
这样，Word文档中的汉字都会附带上拼音。
4. 将Word文档中的数据全选并复制回到Excel表格的B列中。
5. 在C列中，输入“=PH”，并选择第2个公式，引用B1单元格。
整体公式为：“=PHONETIC(B1)”。
6. 按回车键确认后即可得到转换后的结果。
通过以上方法，您可以轻松地将汉字转换为拼音，并将其导入Excel表格中进行分析和处理。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
把汉字转换成拼音
录入学生资料时需要输入姓名的汉字拼音，但怎样才能把姓名转换成拼音呢？
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。