Convertir caracteres chinos a Pinyin en Excel

En el trabajo, necesitamos modificar por lotes los caracteres chinos en formato pinyin para su visualización. Esto se puede lograr fácilmente usando macros en Excel y definiendo un método getpy. La siguiente es una introducción al método.

Abra los datos de la tabla que desea ordenar, como se muestra en la siguiente figura. Presione la tecla de acceso directo alt+f11 para abrir la página de configuración de macro y seleccionar la opción del módulo que se insertará.

En el panel "Módulos" que aparece, defina un método getpy y pegue el siguiente código en él.

La función Pinyin (p es una cadena) es una cadena

i = Asc(p)

Seleccione el caso uno

Caso- 20319 a -20318: Pinyin = "a "

Caso-20317 a-20305: Pinyin = "ai "

Caso-20304 a -20296: Pinyin = "安" p>

Caso -20295 a -20293: pinyin = "ang "

Caso -20292 a -20284: Pinyin = "ao "

Caso -20283 a - 20266: Pinyin = "白"

Caso -20265 a -20258: Pinyin = "白"

Caso -20257 a -20243: pinyin = "ban "

caso-20242 a-20231:pinyin = " bang "

Caso-20230 a-20052: Pinyin = "宝"

Caso -20051 a -20037: Pinyin = "北"

Caso -20036 A -20033: pinyin = "ben "

Caso-20032 A-20027:pinyin = " beng "

Caso -20026 To - 20003: pinyin = "bi "

caso-20002 To-19991:pinyin = " bian "

Caso-19990 transfer-19987: pinyin = "biao"

Caso-19986 transferencia-19983: Pinyin = "bie "

Caso-19982 transferencia-19977: Pinyin = "bin "

Caso-19976 transferencia-19806: Pinyin = " bing "

Caso-19805 transfer-19785: Pinyin = "bo "

Caso-19784 transfer-19776: Pinyin = "bu "

Caso -19775 To-19775: Pinyin= "ca"

Caso-19774 transfer-19764: Pinyin= "Cai"

Caso-19763 transfer-19757: Pinyin= "can"

Caso-19756 transferencia-19752: Pinyin = "Cang"

Caso-19751 a-19747: Pinyin = "Cao"

Caso-19746 transferencia-19742 : Pinyin = "ce "

Caso-19741 a-19740:pinyin = "成"

caso-19739 A-19729:pinyin = " cha "

Caso -19728 transferencia-19726: Pinyin = "Chai"

Caso-19725 transferencia-19716: pinyin = " chan "

caso-19715 To-19541: Pinyin = "chang "

Caso -19540 a -19532: Pinyin = "chao "

Caso -19531 a -19526: pinyin = "che "

Caso -19525 a -19516 :Pinyin = "陈"

caso-19515 A-19501:Pinyin = "成"

Caso-19500 transferencia-19485:Pinyin = "Chi"

Caso-19484 transferencia-19480: Pinyin = "chong "

Caso-19479 transferencia-19468: Pinyin = "chou "

Caso-19467 transferencia-19290: Pinyin = "chu "

Caso-19289 transferencia-19289: Pinyin = "嘬"

Caso-19288 transferencia-19282

:pinyin = "chuan"

Caso-19281 a-19276:pinyin = "chuang"

Caso-19275-19271:pinyin = "chui"

Caso-19270 transferencia-19264: Pinyin = "chun "

Caso-19263 transferencia-19262: pinyin = "chuo "

Caso-19261 a-19250: Pinyin = "ci "

Caso-19249 a-19244: Pinyin = "Cong"

Caso-19243 a-19243: Pinyin = "cou "

Caso-19242 a - 19239: Pinyin= "cu "

Caso-19238 transferencia-19236: Pinyin= "cuan"

Caso-19235 transferencia-19228: Pinyin= "Cui"

Caso-19227 transfer-19225: Pinyin= "pulgada"

Caso-19224 transfer-19219: Pinyin= "cuo"

Caso-19218 transfer-19213: Pinyin= " da "

Caso-19212 a-19039: Pinyin = "Dai"

Caso-19038 a-19024: Pinyin = "Dan"

Caso- 19023 transfer-19019: Pinyin = "dang "

caso-19018 To-19007: pinyin = " Dao "

Caso-19006 transfer-19004: Pinyin = "de "

Caso-19003 a-18997: Pinyin= "Deng"

Caso-18996 transferencia-18978: Pinyin= "di"

Caso-18977 transferencia-18962: Pinyin = "point"

Caso -18961 a -18953: pinyin = "diao "

Caso -18952 a -18784: Pinyin = "die"

Caso -18783 transferencia-18775: Pinyin = "ding"

Caso-18774 transferencia-18774: Pinyin = "diu"

Caso-18773 transferencia-18527: Pinyin = "dong"

Caso-18526 transferencia-18519: Pinyin = "fa "

Caso-18518 transferencia-18502: Pinyin = "fan "

Caso-18501 a- 18491 : Pinyin = "方"

Caso-18490 transferencia-18479: Pinyin= "Fei"

Caso-18478 transferencia-18464: Pinyin="fen"

Caso-18463 transferencia-18449: Pinyin = "Feng"

Caso-18448 transferencia-18448: Pinyin = "fo "

Caso-18447 a -18447: Pinyin = " fou "

Caso -18446 a -18240: Pinyin = "fu "

Caso-18239 a -18238: Pinyin = "ga "

Caso-18237 Transferencia -18232: Pinyin = "gai "

Caso -18231 Transferencia-18221: Pinyin = "gan"

Caso-18220 Transferencia-18212: Pinyin = "pandilla "

Caso-18211 a-18202: Pinyin = "高"

Caso-18201 a-18185: Pinyin = "Ge"

Caso-18184 a-18184: Pinyin = "gei "

Caso-18183 transfer-18182: Pinyin = "gen "

Caso -18181 transfer-18013: Pinyin = "geng"

Caso - 18012 transferencia-17998: Pinyin = "Gong"

Caso-17997 transferencia-17989: Pinyin

= "gou "

Caso-17988 a-17971: Pinyin = "Gu"

Caso-17970 a-17965: Pinyin = "gua"

Caso -17964 transfer-17962: pinyin= "guai"

Caso -17961 a-17951: Pinyin= "Guan"

Caso-17950 transfer-17948: Pinyin= "Guang"

Caso-17947 a-17932: Pinyin= "gui"

Caso-17931 transferencia-17929: Pinyin= "gun"

Caso-17928 transferencia-17923 :Pinyin = "Guo"

Caso-17922 transferencia-17760: Pinyin= "ha"

Caso-17759 transferencia-17753: Pinyin= "海"

Caso -17752 a -17734: Pinyin = "han "

Caso -17733 a -17731: Pinyin = "hang "

Caso -17730 a -17722: Pinyin = "Hao "

Caso-17721 a-17704: Pinyin = "Él"

Caso-17703 a-17702: Pinyin = "黑"

Caso-17701 a -17698: Pinyin = "hen "

Caso-17697 transferencia-17693: Pinyin="Heng"

Caso-17692 transferencia-17684: Pinyin= "hong "

Caso-17683 transferencia-17677: Pinyin= "Hou"

Caso-17676 transferencia-17497: Pinyin= "Hu"

Caso-17496 transferencia-17488: Pinyin= "华"

Caso-17487 transfer-17483: Pinyin = "Huai"

Caso-17482 transfer-17469: Pinyin = "Huan"

Caso- 17468 transferencia-17455: Pinyin = "黄"

Caso-17454 transferencia-17434: Pinyin="Hui"

Caso-17433 a-17428: Pinyin= "hun" p>

Caso-17427 transferencia-17418: Pinyin= "Huo"

Caso-17417 a-17203: Pinyin= "Ji"

Caso-17202 transferencia- 17186: Pinyin= "Jia"

Caso-17185 transferencia-16984: Pinyin= "jian"

Caso-16983 transferencia-16971: Pinyin= "Jiang"

Caso-16970 transferencia-16943: Pinyin= "Jiao"

Caso-16942 transferencia-16916: Pinyin= "jie"

Caso-16915 transferencia-16734: Pinyin= "金"

Caso-16733 transfer-16709: Pinyin = "jing "

Caso-16708 transfer-16707: Pinyin = "jiong "

Caso-16706 transfer- 16690: Pinyin = "ju"

Caso -16689 transfer-16665: pinyin = "ju "

Caso-16664 transfer-16658: Pinyin = "juan "

Caso-16657 transfer-16648: Pinyin = "Jue"

Caso-16647 transfer-16475: Pinyin = "jun "

caso-16474 To-16471:pinyin = " ka "

Caso-16470 transfer-16466: Pinyin = "kai "

Caso-16465 transfer-16460: Pinyin = "kan "

Caso -16459 Transferencia-16453: Pinyin = "Kang"

Caso -16452 Transferencia-16449: Pinyin = "kao"

Caso -1

6448 A -16434: Pinyin = "ke "

Caso-16433 transfer-16430: Pinyin= "ken "

Caso-16429 transfer-16428: Pinyin= "keng "

Caso-16427 a-16424: Pinyin= "kou"

Caso-16423 transferencia-16420: Pinyin= "kou"

Caso-16419 transferencia-16413: Pinyin= "ku"

Caso-16412 transfer-16408: Pinyin= "kua"

Caso-16407 transfer-16404: Pinyin= "kuai"

Caso-16403 transferencia-16402: Pinyin = "kuan "

Caso-16401 a-16394: Pinyin = "kuang"

Caso-16393 transferencia-16221: Pinyin = "kui"

Caso-16220 transferencia-16217: Pinyin= "kun"

Caso-16216 transferencia-16213: Pinyin= "kuo"

Caso-16212 transferencia- 16206: Pinyin= "la "

Caso-16205 transferencia-16203: Pinyin= "Lai"

Caso-16202 transferencia-16188: Pinyin= "LAN"

Caso-16187 transfer-16181: Pinyin= "lang"

Caso-16180 transfer-16172: Pinyin= "lao"

Caso -16171 a-16170: pinyin=" le "

Caso-16169 transfer-16159: Pinyin = "雷"

Caso-16158 transfer-16156: Pinyin = "Leng"

Caso-16155 Transfer-15960: Pinyin = "李"

Caso-15959 a -15959: Pinyin = "lia"

Caso-15958 a -15945: Pinyin = "Lian"

Caso-15944 a-15934: Pinyin = "Liang"

Caso-15933 transferencia-15921: Pinyin="Liao"

Caso-15920 transferencia-15916: Pinyin = "mentira"

Caso-15915 a-15904: Pinyin = "Lin"

Caso-15903 a-15890: Pinyin = "Ling"

Caso -15889 transferencia-15879: Pinyin= "Liu"

Caso-15878 transferencia-15708: Pinyin= "largo"

Caso-15707 transferencia-15702: Pinyin= "Lou"

Caso-15701 a-15682: Pinyin = "Lu"

Caso-15681 a-15668: Pinyin = "lv"

Caso-15667 transfer-15662 :Pinyin = "澾"

Caso-15661 a-15660:Pinyin = "lue"

caso-15659 a-15653:pinyin = " LUN "

Caso-15652 a-15641: Pinyin = "Luo"

Caso-15640 a-15632: Pinyin = "马"

Caso-15631 a-15626: Pinyin = "mai "

Caso-15625 transferencia-15455: Pinyin = "man "

Caso-15454 transferencia-15449: Pinyin = "mang "

Caso -15448 A -15437: Pinyin= "mao "

Caso-15436 transfer-15436: Pinyin= "yo"

Caso-15435 transfer-15420: Pinyin= "mei"

Caso-15419 a-15417: Pinyin = "hombres "

Caso-15416 a-15409: Pinyin =

"Meng"

Caso -15408 a -15395: Pinyin = "mi "

Caso -15394 a -15386: Pinyin = "mian "

Caso - 15385 transfer-15378: Pinyin= "Miao"

Caso-15377 transfer-15376: Pinyin= "mie"

caso-15375 To-15370: pinyin= " min " p>

Caso-15369 transferencia-15364: Pinyin= "明"

Caso-15363 transferencia-15363: Pinyin= "miu"

Caso-15362 transferencia- 15184: Pinyin= "mo "

Caso-15183 transfer-15181: Pinyin= "Mo"

Caso-15180 transfer-15166: Pinyin= "mu "

case-15165 To-15159: Pinyin = "na "

Caso-15158 transfer-15154: Pinyin = "nai "

case-15153 To-15151: pinyin = " nan "

caso-15150 To-15150:pinyin = " nang "

Caso-15149 transfer-15145: Pinyin = "nao "

Caso-15144 transfer- 15144: Pinyin = "ne "

Caso-15143 a-15142: Pinyin = "nei"

Caso-15141 a-15141: pinyin = "nen"

Caso-15140 transfer-15140: Pinyin= "can"

Caso-15139 transfer-15129: Pinyin= "ni"

caso-15128 To-15122: Pinyin = " Año"

Caso-15121 a-15120: Pinyin = "媛"

caso-15119 A-15118: pinyin = " niao "

Caso -15117 Transferencia-15111: Pinyin= "nie"

Caso-15110 a-15110: Pinyin= "nin"

Caso-15109 transferencia-14942: Pinyin= "Ning"

Caso-14941 a-14938: Pinyin = "Vaca"

Caso-14937 a-14934: Pinyin = "Nong"

caso-14933 a-14931 :pinyin = " nu "

caso-14930 A-14930:pinyin = " NV "

Caso-14929 a-14929:pinyin = "nuan "

Caso -14928 transfer-14927: Pinyin= "nue"

Caso-14926 transfer-14923: Pinyin="nue"

Caso-14922 a -14922: Pinyin= "o "

Caso -14921 a -14915: Pinyin = "ou "

Caso -14914 a -14909: Pinyin = "pa "

Caso -14908 transferido a -14903 :Pinyin = "pai "

Caso-14902 a-14895: Pinyin="pan"

Caso-14894 a-14890: Pinyin="Pang"

Caso-14889 a -14883: Pinyin = "pao "

Caso-14882 transferencia-14874: Pinyin = "pei "

Caso -14873 transferencia-14872: Pinyin = "pen "

Caso-14871 a-14858: Pinyin = "Peng"

Caso-14857 a-14679: Pinyin="pi"

Caso -146

78 a -14675: Pinyin = "pian "

Caso-14674 transfer-14671:pinyin = " Piao "

Caso-14670 transfer-14669: Pinyin= "pie" p>

Caso-14668 a-14664: Pinyin= "pin"

Caso-14663 transferencia-14655: Pinyin= "ping"

Caso-14654 transferencia- 14646: Pinyin = "po "

caso-14645 A-14631:pinyin = " pu "

Caso-14630 a-14595: Pinyin = "Qi"

Caso-14594 transferencia-14430: Pinyin= "qia"

Caso-14429 transferencia-14408: Pinyin= "qian"

Caso-14407 transferencia-14400: Pinyin= " qiang"

Caso-14399 transfer-14385: Pinyin= "Qiao"

Caso-14384 transfer-14380: Pinyin= "qie"

Caso-14379 transfer- 14369: Pinyin= "Qin"

Caso -14368 transfer-14356: Pinyin= "qing"

Caso-14355 a -14354: Pinyin= " qiong "

Caso-14353 transferencia-14346: Pinyin= "Qiu"

caso-14345 To-14171: Pinyin= "Qu"

Caso-14170 transferencia-14160: Pinyin = " quan "

caso-14159 To-14152:pinyin = " que "

caso-14151 To-14150:pinyin = " qun "

Caso -14149 Turno-14146: Pinyin = "Ran"

caso-14145 To-14141:pinyin = "rang"

Caso-14140 Turn-14138: Pinyin= "Rao"

caso-14137 To-14136:pinyin = " re "

Caso-14135 transferencia-14126: Pinyin = "人"

caso-14125 To-14124 :pinyin = " reng "

caso-14123 To-14123:pinyin = " ri "

Caso-14122 a-14113:pinyin = "Rong"

caso -14112 To-14110:pinyin = " rou "

caso-14109 To-14100:pinyin = " ru "

Caso-14099 a -14098: pinyin = "阮"

Caso-14097 transferencia-14095: Pinyin = "rui "

Caso-14094 transferencia-14093: Pinyin = "ejecutar "

Caso -14092 transferencia -14091 : pinyin = "ruo "

Caso-14090 a -14088: Pinyin = "sa "

Caso-14087 a -14084: Pinyin = "sai "

caso-14083 A-13918:pinyin = " San "

Caso-13917 a-13915: Pinyin = "San"

Caso-13914 a-13911:pinyin = " Sao "

Caso-13910 a-13908: Pinyin = "se "

Caso-13907 transfer-13907: Pinyin = "sen "

Caso- 13906 a -13906: Pinyin = "seng "

Caso-13905 a-13897: Pinyin= "sha"

Caso-13896 transferencia-13895: Pinyin= "shai"

Caso-13894 transferencia- 13879: Pinyin= "山"

Caso-13878 transferencia-13871: Pinyin= "Shang"

Caso-13870 transferencia-13860: Pinyin= "Shao"

Caso-13859 transferencia-13848: Pinyin = "ella "

Caso-13847 transferencia-13832: Pinyin = "Shen"

Caso -13831 a-13659: Pinyin = " Sheng"

Caso-13658 a-13612: Pinyin = "Shi"

Caso-13611 a-13602: Pinyin = "shou"

Caso-13601 To-13407: Pinyin= "shu"

Caso-13406 transfer-13405: ​​Pinyin= "shua"

Caso-13404 transfer-13401: Pinyin= "guapo"

Caso-13400 transferencia-13399: Pinyin= "shuan"

Caso-13398 transferencia-13396: Pinyin= "doble"

Caso-13395 transferencia-13392 : Pinyin= "agua"

Caso-13391 transfer-13388: Pinyin= "Shun"

Caso-13387 transfer-13384: Pinyin= "Shuo"

Caso -13383 a -13368: Pinyin = "si "

Caso-13367 transfer-13360: Pinyin = "Canción"

caso-13359 A-13357:pinyin = " sou "

Caso-13356 transferencia-13344: Pinyin = "苏"

Caso-13343 transferencia-13341: Pinyin= "suan "

Caso-13340 transferencia -13330 :Pinyin = "苏"

Caso-13329 transferencia-13327: Pinyin= "Sol"

Caso-13326 transferencia-13319: Pinyin= "Suo"

Caso-13318 transfer-13148: Pinyin = "ta "

Caso-13147 transfer-13139: Pinyin = "tai "

caso-13138 To-13121:pinyin = " tan "

Caso-13120 transfer-13108: Pinyin= "Tang"

Caso-13107 transfer-13097: Pinyin= "Tao"

Caso- 13096 transferencia -13096: Pinyin = "te "

Caso -13095 a -13092: Pinyin = "Teng"

Caso -13091 a -13077: pinyin = "ti "

Caso-13076 a-13069: Pinyin = "田"

Caso-13068 a-13064: Pinyin = "Tiao"

caso-13063 a-13061: pinyin = " tie "

Caso-13060 transfer-12889: Pinyin = "ting "

Caso-12888 transfer-12876: Pinyin = "Tong"

Caso- 12875 transfer-12872: Pinyin = "tou "

Caso -12871 a-12861: pinyin = "tu "

Caso -12860 transfer-12859: Pinyin = "tuan "

Caso-12858 transferencia-12853: Pinyin= "tui "

Caso-12852 a -12850: Pinyin= "tun "

Caso-12849 transferencia- 12839: Pinyin = "Tuo"

Caso-12838 a -12832: Pinyin = "wa "<

/p>

Caso-12831 transferencia-12830: Pinyin= "wai"

Caso-12829 transferencia-12813: Pinyin= "wan"

Caso-12812 a -12803 :Pinyin = "王"

Caso-12802 transferencia-12608: Pinyin= "Wei"

Caso-12607 transferencia-12598: Pinyin= "文"

Caso-12597 transferencia-12595: Pinyin = "王"

Caso-12594 transferencia-12586: Pinyin = "wo"

Caso-12585 transferencia-12557: Pinyin = "武"

Caso-12556 transferencia-12360: Pinyin= "xi "

Caso-12359 transferencia-12347: Pinyin= "Xia"

Caso-12346 transferencia -12321: Pinyin = "xian "

caso-12320 To-12301: Pinyin = "xiang"

Caso-12300 transferencia-12121: Pinyin = "小"

Caso-12120 transferencia-12100: Pinyin= "Xie"

Caso-12099 transferencia-12090: Pinyin= "xin"

Caso-12089 transferencia-12075: Pinyin= "xing "

Caso-12074 transferencia-12068: Pinyin = "Xiong"

Caso-12067 transferencia-12059: Pinyin= "Xiu"

Caso- 12058 transferencia-12040: Pinyin= "Xu"

Caso-12039 transferencia-11868: Pinyin= "Xuan"

Caso-11867 transferencia-11862: Pinyin= "Xue"

Caso-11861 transferencia-11848: Pinyin = "xun "

Caso-11847 transferencia-11832: Pinyin = "ya "

Caso-11831 transferencia-11799: Pinyin = "yan "

Caso-11798 transferencia-11782: Pinyin= "Yang"

Caso-11781 transferencia-11605: Pinyin= "Yao"

Caso-11604 transferencia-11590: Pinyin = "叶"

caso-11589 To-11537: Pinyin = "yi"

Caso -11536 transferencia-11359: Pinyin = "yin "

Caso-11358 transferencia-11341: Pinyin = "ying "

Caso-11340 transferencia-11340: Pinyin = "yo "

Caso -11339 transferencia- 11325: Pinyin = "yong "

Caso-11324 transferencia-11304: Pinyin="tú"

Caso-11303 transferencia-11098: Pinyin= "Yu"

Caso-11097 transferencia-11078: Pinyin= "Yuan"

Caso-11077 transferencia-11068: Pinyin= "Yue"

Caso-11067 transferencia-11056: Pinyin= " Nube"

Caso-11055 transferencia-11053: Pinyin = "za "

Caso-11052 transferencia-11046: Pinyin = "zai "

Caso-11045 Transferencia -11042: Pinyin = "zan "

Caso -11041 a -11039: Pinyin = "Zang"

caso-11038 A-11025: Pinyin = "zao "

Caso-11024 transferencia-11021: Pinyin = "ze "

Caso-11020 transferencia-11020: pinyin = "zei "

Caso-11019 transferencia-11019: Pinyin = "Zen"

caso-11018 A-11015:Pinyin= "Zeng"

caso-11014 A-10839:Pinyin= "zh

a "

Caso -10838 a -10833: Pinyin = "Zhai"

Caso -10832 a -10816: Pinyin = "Zhan"

caso-10815 To-10801: Pinyin = "Zhang"

Caso-10800 transfer-10791: Pinyin = "Zhao"

caso-10790 To-10781:pinyin = "zhe"

Caso-10780 transferencia-10765: Pinyin = "zhen "

Caso-10764 transferencia-10588: Pinyin = "Zheng"

Caso-10587 transferencia-10545: Pinyin = "zhi "

Caso -10544 a -10534: Pinyin = "Zhong"

Caso -10533 a -10520: Pinyin = "Zhou"

Caso -10519 a -10332: Pinyin = "Zhu"

Caso -10331 a -10330: pinyin = "zhua "

Caso -10329 a -10329: Pinyin = "zhuai "

Caso -10328 A -10323: Pinyin = "zhuan "

Caso-10322 transfer-10316: Pinyin = "zhuan"

caso-10315 A-10310 :pinyin = " zhui "

Caso-10309 a -10308: Pinyin = "Zhun"

Caso-10307 a -10297: Pinyin = "Zhuo"

Caso-10296 transferencia-10282: Pinyin = "zi "

Caso-10281 a-10275: Pinyin = "Zong"

Caso-10274 transferencia-10271: Pinyin = "Zou "

Caso-10270 transferencia-10263: Pinyin = "zu "

Caso-10262 transferencia-10261: Pinyin = "Anzu"

Caso-10260 Transferencia -10257: Pinyin= "zui"

Caso-10256 Transferencia-10255: Pinyin= "zun"

Caso-10254 Transferencia-10254: Pinyin= "izquierda"

Otros casos: Pinyin = p

Finalizar selección

Finalizar función

Función getpy(str)

Para i = 1 a Len(str)

getpy = getpy & amppinyin(Mid(str, I, 1))

Siguiente yo

Función final

p >

Después de guardar, seleccione la opción Cerrar y volver al formulario.

Ingrese =getpy(A2) en la celda B2 y presione Enter, se convertirá a Pinyin.

Coloque el mouse en la esquina inferior derecha de la celda B2. Cuando el puntero cambie a una cruz sólida, mantenga presionado el botón izquierdo del mouse y tire hacia abajo. De esta forma, aplicando este método, todas las células quedarán pinyinizadas.