Convertir caracteres chinos a Pinyin en Excel
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, define un método getpy y pega 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"< /p >
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 transfer-19726: Pinyin = "Chai"
Caso-19725 transfer-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 transferencia -17962: pinyin = "guai "
Caso -17961 a -17951: Pinyin = "Guan"
Caso -17950 transferencia -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 a-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 transferencia-15181: Pinyin= "Mo"
Caso-15180 transferencia-15166: Pinyin= "mu "
case-15165 To-15159: Pinyin = "na "
Case-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"< /p >
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 a-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"< /p >
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"< /p >
Caso-13400 transferencia-13399: Pinyin= "shuan"
Caso-13398 transferencia-13396: Pinyin= "doble"
Caso-13395 transferencia-13392 : Pinyin= "agua"
Caso-13391 transferencia-13388: Pinyin= "Shun"
Caso-13387 transferencia-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.