Excel은 중국어를 대문자 병음으로 변환합니다. 예: Zhang Xiaoxiao ZHANG XIAOXIA는 이것으로 변환됩니다. 대답해 주시거나 직접 변환하도록 도와주실 수 있습니까?

명시적 옵션

옵션 비교 텍스트

공개 함수 HZQP(표현식을 문자열로, 선택적 구분 기호를 문자열로 = " ", 선택적 제한을 정수로 = -1) 문자열로

'표현식

' 필수 변환할 문자열을 포함합니다.

'구분 기호

' 선택 사항. 병음 구분 문자를 식별하는 데 사용되는 문자열 문자입니다. 생략할 경우 공백 문자(" ")가 구분 기호로 사용됩니다. delimiter가 길이가 0인 문자열인 경우 요소가 하나만 포함된 전체 표현식 문자열이 반환됩니다.

'한계

' 선택사항. 병음 문자 수를 반환하려면 -1은 모든 병음 문자 수를 반환한다는 의미이고, 1은 병음의 첫 글자를 반환한다는 의미입니다.

Dim STR As String, arrWord(400) As String

Dim i As Integer, j As Integer

arrWord(1) = "吖a"

arrWord(2) = "안녕 ai"

arrWord(3) = "안녕"

arrWord(4) = "더러운 놈"

arrWord(5) = "匀ao"

arrWord(6) = "八ba"

arrWord(7) = "挀bai"

arrWord(8) = "금지"

arrWord(9) = "쾅"

arrWord(10) = "금바오"

arrWord( 11) = "邂bei"

arrWord(12) = "벤 벤"

arrWord(13) = "벵 벵"

arrWord( 14) = "皀bi"

arrWord(15) = "bian"

arrWord(16) = "暓biao"

arrWord(17) = "拆bie"

arrWord(18) = "bin"

arrWord(19) = "仌bing"

arrWord(20) = " 다이얼 보"

arrWord(21) = "嬬bu"

arrWord(22) = "嚓ca"

arrWord(23) = "guess cai"

p>

arrWord(24) = "can"

arrWord(25) = "cangcang"

arrWord(26) = "canangcang"

arrWord(27) = "嵌cen"

arrWord(28) = "嵾cen"

arrWord(29) = "嵌cen"

arrWord(30) = "*차"

arrWord(31) = "차이"

arrWord(32) = "차"

arrWord( 33) = "장"

arrWord(34) = "chao"

arrWord(35) = "체체"

arrWord(36) = "抻chen"

arrWord(37) = "阷cheng"

arrWord(38) = "吃chi"

arrWord( 39) = "충전" chong"

arrWord(40) = "슈를 그리다"

arrWord(41) = "추"

arrWord(42) = "추아이"

arrWord(43) = "추앙"

arrWord(44) = "추앙"

arrWord(45) = "추앙"

arrWord(46) = "澾chun"

arrWord(47) = "蔔chuo"

arrWord(48) = "呲ci "

arrWord(49) = "콩에서"

arrWord(50) = "cou cou"

arrWord(51) = "거친 cu"

arrWord(52) = "쿠안"

>

arrWord(53) = "전체"

arrWord(54) = "전체"

arrWord(55) = "전체"

arrWord(56) = "단단"

arrWord(57) = "다이"

arrWord(58) = "단단"

arrWord( 59) = "당"

arrWord(60) = "칼 다오"

arrWord(61) = "恴de"

arrWord( 62) = "lamp deng"

arrWord(63) = "디안"

arrWord(64) = "디안"

arrWord(65) = "디아오 diao"

arrWord(66) = "죽음"

arrWord(67) = "ding ding"

arrWord(68) = " 잃다 diu"

arrWord(69) = "동"

arrWord(70) = "剅dou"

arrWord(71) = "DU "

arrWord(72) = "특별 duan"

arrWord(73) = "垖dui"

arrWord(74) = "ton duan"

arrWord(75) = "많은"

arrWord(76) = "많은"

arrWord(77) = "많은"

arrWord( 78) = "er"

arrWord(79) = "发fa"

arrWord(80) = "fan"

arrWord(81) = "方fang"

arrWord(82) = "飞FEI"

arrWord(83) = "fenfen"

arrWord(84) = "瑑feng"

arrWord(85) = "仏fo"

arrWord(86) = "瑑fou"

arrWord( 87) = "夫fu"

arrWord(88) = "간간"

arrWord(89) = "큰"

arrWord(90) = "간간"

arrWord(91) = "강"

arrWord(92) = "강"

arrWord(93) = "게"

arrWord( 94) = "게이"

arrWord(95) = "겐겐"

arrWord(96) = "겐"

arrWord(97) = "일 "

arrWord(98) = "Gou"

arrWord(99) = "추정"

arrWord(100) = "guagua"

arrWord(101) = "과이과이"

arrWord(102) = "관관"

arrWord(103) = "빛광"

arrWord(104) = "guigui"

arrWord(105) = "총군"

arrWord(106) = "guigui"

arrWord(107) = "하하"

ar

rWord(108) = "안녕하세요"

arrWord(109) = "한"

arrWord(110) = "안녕"

arrWord( 111) = "하오"

arrWord(112) = "그"

arrWord(113) = "헤이"

arrWord(114) = "拫hen"

arrWord(115) = "hengheng"

arrWord(116) = "叫hong"

arrWord(117) = " 허우 "

arrWord(118) = "화"

arrWord(119) = "화화"

arrWord(120) = "화화"

p>

arrWord(121) = "환"

arrWord(122) = "황"

arrWord(123) = "환"

arrWord(124) = "훈훈"

arrWord(125) = "금화"

arrWord(126) = "훈훈"

arrWord( 127) = "jiajia"

arrWord(128) = "戋jian"

arrWord(129) = "강강"

arrWord(130) = "艽jiao"

arrWord(131) = "가족"

arrWord(132) = "jin"

arrWord(133) = "啕jing" "

arrWord(134) = "冂jiong"

arrWord(135) = "丩jiu"

arrWord( 136) = "姥ju"

arrWord(137) = "姢juan"

arrWord(138) = "噘jue"

arrWord(139) = "junjun"

arrWord(140) = "KAKA"

arrWord(141) = "카이"

arrWord(142) = " 저널칸"

arrWord (143) = "忼kang"

arrWord(144) = "*kao"

arrWord(145) = "忼ke"

arrWord(146) ) = "莂ken"

arrWord(147) = "奥keng"

arrWord(148) = "empty kong"

arrWord(149) = "抠kou"

arrWord(150) = "쿠아이쿠"

arrWord(151) = "쿠아쿠아"

arrWord(152) = "쿠아이쿠아이 "

arrWord(153) = "kuankuan"

arrWord(154) = "kuangkuang"

arrWord(155) = "kuangkui"

arrWord(156) = "kunkun"

arrWord(157) = "말"

arrWord(158) = "kunkun"

arrWord(159) = "라이"

arrWord(160) = "LAN lan"

arrW

ord(161) = "언어"

arrWord(162) = "언어"

arrWord(163) = "언어"

arrWord( 164) = "금"

arrWord(165) = "길이"

arrWord(166) = "금"

arrWord(167) = "말"

arrWord(168) = "말"

arrWord(169) = "말"

arrWord(170) = "载liao"

arrWord(171) = "거짓말"

arrWord(172) = "림림"

arrWord(173) = "거짓말"

arrWord(174) = "금"

arrWord(175) = "금"

arrWord(176) = "금"

p>

arrWord(177) = "루루"

arrWord(178) = "루루"

arrWord(179) = "당나귀 lv"

arrWord(180) = "TWIN lun"

arrWord(181) = "LUE"

arrWord(182) = "TWIN lun"

arrWord(183) = "엄마"

arrWord(184) = "엄마"

arrWord(185) = "엄마를 묻어주세요"

arrWord(186 ) = "고양이 마오"

arrWord(187) = "고양이 마오"

arrWord(188) = "고양이 마오"

arrWord( 189) = "나"

arrWord(190) = "메이"

arrWord(191) = "남자"

arrWord(192) = "메이" meng"

arrWord(193) = "Mi mi"

arrWord(194) = "芇mian"

arrWord(195) = " mi ao"

arrWord(196) = "명명"

arrWord(197) = "민민"

arrWord(198) = "명명"

arrWord(199) = "哞miu"

arrWord(200) = "mo 터치"

arrWord(201) = "哞mou"

arrWord(202) = "어머니 뮤"

arrWord(203) = "나를 취하세요"

arrWord(204) = "무"

arrWord(205) = "금"

arrWord(206) = "금"

arrWord(207) = "금"

arrWord( 208) = "nene"

arrWord(209) = "nenei"

arrWord(210) = "nenen"

arrWord(211) = "Neng neng"

arrWord(212) = "금"

arrWord(213) = "금"

arrWord( 214) = "

niang"

arrWord(215) = "niao"

arrWord(216) = "nie"

arrWord(217) = "茌nin"

arrWord(218) = "농농"

arrWord(219) = "농농"

arrWord(220) = "농농"

arrWord(221) = "누에"

arrWord(222) = "여성 nv"

arrWord(223) = "말라리아 누에"

arrWord (224) = "오후"

arrWord(225) = "오후"

arrWord(226) = "오호"

arrWord(227) = "당신"

arrWord(228) = "빠"

arrWord(229) = "빠빠이"

arrWord(230) = "眅pan"

arrWord(231) = "퐁팡"

arrWord(232) = "파오를 던지다"

arrWord( 233) = "呸pei"

arrWord(234) = "펜"

arrWord(235) = "펜"

arrWord(236) = "PIpi"

arrWord(237) = "PIAN"

arrWord(238) = "피아오"

arrWord(239) = "파이"

arrWord(240) = "핀 고정"

arrWord(241) = "핀 고정"

arrWord(242) = "핀 고정"

arrWord (243) = "PUpu"

arrWord(244) = "七qi"

arrWord(245) = "Qiaqia"

arrWord(246) = "Qianqian"

arrWord(247) = "呛qiang"

arrWord(248) = "Qiaoqiao"

arrWord(249) = "Qie qie"

arrWord(250) = "진 진"

arrWord(251) = "靑qing"

arrWord(252) = "宆qiong"

p>

arrWord(253) = "구구"

arrWord(254) = "구구"

arrWord(255) = "구구"

arrWord(256) = "죽음"

arrWord(257) = "죽음"

arrWord( 258) = "죽음"

arrWord(259) = "穣rang"

arrWord(260) = "荛rao"

arrWord(261) "ri"

arrWord(265 ) = "rong"

arrWord(266) = "厹rou"

arrWord(267) = "嶿ru "

>

arrWord(268) = "루안"

arrWord(269) = "루안"

arrWord(270) = "루안"

arrWord(271) = "말"

arrWord(272) = "말"

arrWord(273) = "말"

arrWord(274) = "삼상"

arrWord(275) = "삼상"

arrWord(276) = "삼상"

arrWord( 277) = "색"

arrWord(278) = "센"

arrWord(279) = "승려님"

arrWord(280) = "샤샤"

arrWord(281) = "스크린 샤이"

arrWord(282) = "산샨"

arrWord(283) = " 상처 shang"

arrWord(284) = "尰shao"

arrWord(285) = "럭셔리한 그녀"

arrWord(286) = "深圳"

arrWord(287) = "셩"

arrWord(288) = "시체"

arrWord(289) = "받기"

arrWord(290) = "슈아이"

arrWord(291) = "브러시 슈아이"

arrWord(292) = "나쁜 슈아이"

arrWord (293) = "婷 shuang"

arrWord(294) = "서리 shuang"

arrWord(295) = "Who shui"

arrWord(296 ) = "囶shun"

arrWord(297) = "说shuo"

arrWord(298) = "厶si"

arrWord(299) = "媪song"

arrWord(300) = "凁sou"

arrWord(301) = "苏su"

arrWord( 302) = "绋suan"

arrWord(303) = "夊sui"

arrWord(304) = "孙sun"

arrWord(305) = "선동 suo"

arrWord(306) = "TA"

arrWord(307) = "囼tai"

arrWord(308) = " 탄탄"

arrWord(309) = " Tangtang"

arrWord(310) = "仐tao"

arrWord(311) = "翑te"

arrWord(312) = "鼟teng"

arrWord(313) = "ticti"

arrWord(314) = "천천"

arrWord(315) = "嗫tiao"

arrWord(316) = "tie"

arrWord(317) = "ting"

arrWord(318) = "囲tong" "

arrWord(319) = "당신을 훔치는 중"

arrWord(320) = "

볼록한 tu"

arrWord(321) = "난류 tuan"

arrWord(322) = "push tui"

arrWord(323) = "囧tun "

arrWord(324) = "불"

arrWord(325) = "불"

arrWord(326) = "와이와이"< / p>

arrWord(327) = "완완"

arrWord(328) = "완전"

arrWord(329) = "위험"

arrWord(330) = "원"

arrWord(331) = "원웽"

arrWord(332) = "라오스"

arrWord( 333) = "무우"

arrWord(334) = "서서"

arrWord(335) = "무우"

arrWord(336) = "Xianxian"

arrWord(337) = "Xiangxiang"

arrWord(338) = "灱xiao"

arrWord( 339) = "Some xie"

arrWord(340) = "心xin"

arrWord(341) = "Xingxing"

arrWord(342) = "鈌xiong"

arrWord(343) = "수수"

arrWord(344) = "수수"

arrWord(345) = "수수"

arrWord(346) = "xue"

arrWord(347) = "xun"

arrWord(348) = "Yaya"

arrWord (349) = "yan"

arrWord(350) = "양"

arrWord(351) = "Yao 초대"

arrWord(352) = "예예"

arrWord(353) = "一yi"

arrWord(354) = "음"

arrWord(355) = "잉" "

arrWord(356) = "요요"

arrWord(357) = "하녀용"

arrWord(358) = "너요"

arrWord(359) = "유"

arrWord(360) = "원"

arrWord(361) = "유"

arrWord(362) = "금"

arrWord(363) = "금"

arrWord( 364) = "금"

arrWord(365) = "兂zan"

arrWord(366) = "炂zang"

arrWord(367) = "궁자오"

arrWord(368) = "啫ze"

arrWord(369) = "thief zei"

arrWord(370) = "선(禪)"

arrWord( 371) = "曽zeng"

arrWord(372) = "吒zha"

arrWord(373) = "夈zhai "