명시적 옵션
옵션 비교 텍스트
공개 함수 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"
p>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" p>
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 "
>arrWord(374) = "장장"
arrWord(375) = "장장"
arrWord(376) = "장장"
arrWord (377) = "臇zhe"
arrWord(378) = "凧zhen"
arrWord(379) = "凧zhen"
arrWord(380 ) = "中zhi"
arrWord(381) = "中zhong"
arrWord(382) = "zhouzhou"
arrWord(383) = " Zhu zhu"
arrWord(384) = "azhua"
arrWord(385) = "zhuai"
arrWord(386) = "special zhuan"
arrWord(387) = "zhuang"
arrWord(388) = "금주이"
arrWord(389) = "宒zhun"
arrWord(390) = "좌탁"
arrWord(391) = "자자"
arrWord(392) = "종종"
p>
arrWord(393) = "조주"
arrWord(394) = "조주"
arrWord(395) = "조주"
arrWord(396) = "厜zui"
arrWord(397) = "Zun zun"
arrWord(398) = "어제 zuo"
arrWord(399) = "咗zuo"
For i = 1 To Len(표현식)
STR = Mid(표현식, i, 1)
If (Asc(STR) < 0) Then
For j = 1 To 399
If Left(arrWord(j), 1) > STR Then
If Limit = -1 그러면
STR = Mid(arrWord(j - 1), 2) & 구분 기호
Else
STR = Mid(arrWord(j - 1), 2, 제한) 및 구분 기호
End If
Exit For
End If
Next
End If
HZQP = HZQP + STR
다음
HZQP = 왼쪽(HZQP, Len(HZQP) - Len(구분자))
함수 종료
Excel에서 매크로를 생성하고, 다음 내용을 입력한 후 Excel에서 사용자 정의 함수를 사용합니다. =hsqp(문자 표현, "", 스위치 매개변수)
세 가지 용도: =hzqp(A2,"",-1)
=hzqp(A2,"-",-1) =hzqp(A2," ",-1)
단어 공식 병음 공식
우리 여자 여자 여자 남자 여자
=hzqp(A2,"",-1) =hzqp(A2,"-",-1) =hzqp(A2," ",-1)
세 가지 방법 그것을 사용하십시오 : =hzqp(A2,"",-1) =hzqp(A2,"-",-1) =hzqp(A2," ",-1)