excel汉字转拼音不带声调

Excel汉字转拼音不带声调的多种解决方案

方法一：利用VBA自定义函数

VBA (Visual Basic for Applications) 是嵌入在 Microsoft Office 中的编程语言，可以用来扩展 Excel 的功能。通过编写自定义函数，我们可以实现汉字转拼音的功能。

1. 打开VBA编辑器： 在Excel中，按下Alt + F11快捷键，打开VBA编辑器。

2. 插入模块： 在VBA编辑器中，点击“插入” -> “模块”。

3. 编写VBA代码： 在新建的模块中，输入以下VBA代码：

“`vba
Function PinYin(ParamArray x()) As Variant
Dim i As Long, j As Long, p As String, str As String
Dim PYstr As Variant
PYstr = Array(“a”, “ai”, “an”, “ang”, “ao”, “ba”, “bai”, “ban”, “bang”, “bao”, “bei”, “ben”, “beng”, “bi”, “bian”, “biao”, “bie”, “bin”, “bing”, “bo”, “bu”, “ca”, “cai”, “can”, “cang”, “cao”, “ce”, “cen”, “ceng”, “cha”, “chai”, “chan”, “chang”, “chao”, “che”, “chen”, “cheng”, “chi”, “chong”, “chou”, “chu”, “chua”, “chuai”, “chuan”, “chuang”, “chui”, “chun”, “chuo”, “ci”, “cong”, “cou”, “cu”, “cuan”, “cui”, “cun”, “cuo”, “da”, “dai”, “dan”, “dang”, “dao”, “de”, “deng”, “di”, “dian”, “diao”, “die”, “ding”, “diu”, “dong”, “dou”, “du”, “duan”, “dui”, “dun”, “duo”, “e”, “ei”, “en”, “eng”, “er”, “fa”, “fan”, “fang”, “fei”, “fen”, “feng”, “fo”, “fou”, “fu”, “ga”, “gai”, “gan”, “gang”, “gao”, “ge”, “gei”, “gen”, “geng”, “gong”, “gou”, “gu”, “gua”, “guai”, “guan”, “guang”, “gui”, “gun”, “guo”, “ha”, “hai”, “han”, “hang”, “hao”, “he”, “hei”, “hen”, “heng”, “hong”, “hou”, “hu”, “hua”, “huai”, “huan”, “huang”, “hui”, “hun”, “huo”, “ji”, “jia”, “jian”, “jiang”, “jiao”, “jie”, “jin”, “jing”, “jiong”, “jiu”, “ju”, “juan”, “jue”, “jun”, “ka”, “kai”, “kan”, “kang”, “kao”, “ke”, “kei”, “ken”, “keng”, “kong”, “kou”, “ku”, “kua”, “kuai”, “kuan”, “kuang”, “kui”, “kun”, “kuo”, “la”, “lai”, “lan”, “lang”, “lao”, “le”, “lei”, “leng”, “li”, “lia”, “lian”, “liang”, “liao”, “lie”, “lin”, “ling”, “liu”, “long”, “lou”, “lu”, “lv”, “luan”, “lue”, “lun”, “luo”, “ma”, “mai”, “man”, “mang”, “mao”, “me”, “mei”, “men”, “meng”, “mi”, “mian”, “miao”, “mie”, “min”, “ming”, “miu”, “mo”, “mou”, “mu”, “na”, “nai”, “nan”, “nang”, “nao”, “ne”, “nei”, “nen”, “neng”, “ni”, “nian”, “niang”, “niao”, “nie”, “nin”, “ning”, “niu”, “nong”, “nou”, “nu”, “nv”, “nuan”, “nue”, “nuo”, “o”, “ou”, “pa”, “pai”, “pan”, “pang”, “pao”, “pei”, “pen”, “peng”, “pi”, “pian”, “piao”, “pie”, “pin”, “ping”, “po”, “pou”, “pu”, “qi”, “qia”, “qian”, “qiang”, “qiao”, “qie”, “qin”, “qing”, “qiong”, “qiu”, “qu”, “quan”, “que”, “qun”, “ran”, “rang”, “rao”, “re”, “ren”, “reng”, “ri”, “rong”, “rou”, “ru”, “ruan”, “rui”, “run”, “ruo”, “sa”, “sai”, “san”, “sang”, “sao”, “se”, “sen”, “seng”, “sha”, “shai”, “shan”, “shang”, “shao”, “she”, “shen”, “sheng”, “shi”, “shou”, “shu”, “shua”, “shuai”, “shuan”, “shuang”, “shui”, “shun”, “shuo”, “si”, “song”, “sou”, “su”, “suan”, “sui”, “sun”, “suo”, “ta”, “tai”, “tan”, “tang”, “tao”, “te”, “teng”, “ti”, “tian”, “tiao”, “tie”, “ting”, “tong”, “tou”, “tu”, “tuan”, “tui”, “tun”, “tuo”, “wa”, “wai”, “wan”, “wang”, “wei”, “wen”, “weng”, “wo”, “wu”, “xi”, “xia”, “xian”, “xiang”, “xiao”, “xie”, “xin”, “xing”, “xiong”, “xiu”, “xu”, “xuan”, “xue”, “xun”, “ya”, “yan”, “yang”, “yao”, “ye”, “yi”, “yin”, “ying”, “yong”, “you”, “yu”, “yuan”, “yue”, “yun”, “za”, “zai”, “zan”, “zang”, “zao”, “ze”, “zei”, “zen”, “zeng”, “zha”, “zhai”, “zhan”, “zhang”, “zhao”, “zhe”, “zhen”, “zheng”, “zhi”, “zhong”, “zhou”, “zhu”, “zhua”, “zhuai”, “zhuan”, “zhuang”, “zhui”, “zhun”, “zhuo”, “zi”, “zong”, “zou”, “zu”, “zuan”, “zui”, “zun”, “zuo”)
Dim ASCstr As Variant
ASCstr = Array(-20319, -20317, -20304, -20295, -20292, -20283, -20265, -20257, -20242, -20230, -20214, -20209, -20195, -20192, -20187, -20183, -20177, -20174, -20169, -20164, -20157, -20150, -20141, -20137, -20133, -20130, -20128, -20123, -20121, -20118, -20114, -20104, -20097, -20094, -20092, -20083, -20076, -20065, -20057, -20054, -20048, -20043, -20036, -20033, -20031, -20027, -20022, -20020, -20016, -20011, -20008, -20003, -19999, -19993, -19984, -19977, -19975, -19969, -19963, -19958, -19952, -19947, -19941, -19932, -19930, -19924, -19921, -19915, -19913, -19905, -19896, -19889, -19882, -19876, -19867, -19863, -19859, -19852, -19849, -19843, -19839, -19830, -19828, -19823, -19812, -19807, -19796, -19792, -19786, -19783, -19775, -19774, -19763, -19756, -19751, -19746, -19741, -19739, -19728, -19725, -19715, -19710, -19690, -19686, -19682, -19679, -19674, -19666, -19663, -19656, -19649, -19641, -19638, -19631, -19629, -19617, -19614, -19608, -19604, -19597, -19592, -19584, -19579, -19575, -19569, -19563, -19555, -19546, -19541, -19534, -19529, -19519, -19512, -19505, -19496, -19490, -19486, -19479, -19467, -19289, -19288, -19281, -19275, -19270, -19263, -19261, -19249, -19243, -19242, -19238, -19235, -19227, -19224, -19218, -19212, -19038, -19037, -19033, -19029, -19027, -19023, -19018, -19006, -19001, -18996, -18980, -18977, -18961, -18952, -18783, -18774, -18773, -18763, -18756, -18741, -18735, -18731, -18722, -18710, -18697, -18696, -18596, -18577, -18575, -18572, -18568, -18561, -18559, -18540, -18531, -18528, -18522, -18521, -18513, -18505, -18496, -18495, -18482, -18473, -18471, -18457, -18449, -18446, -18440, -18435, -18431, -18428, -18422, -18421, -18413, -18404, -18400, -18390, -18384, -18373, -18363, -18353, -18345, -18342, -18340, -18332, -18325, -18319, -18315, -18314, -18286, -18274, -18262, -18257, -18197, -18183, -18176, -18174, -18166, -18152, -18052, -18040, -18039, -18034, -17986, -17982, -17976, -17964, -17961, -17952, -17947, -17931, -17928, -17922, -17912, -17908, -17902, -17889, -17885, -17876, -17867, -17866, -17859, -17852, -17849, -17844, -17835, -17831, -17826, -17819, -17812, -17804, -17799, -17791, -17787, -17779, -17775, -17764, -17758, -17752, -17733, -17730, -17721, -17703, -17701, -17697, -17672, -17662, -17658, -17656, -17654, -17647, -17641, -17636, -17633, -17630, -17627, -17621, -17613, -17609, -17597, -17587, -17583, -17580, -17569, -17562, -17553, -17547, -17544, -17540, -17535, -17533, -17530, -17521, -17510, -17498, -17494, -17486, -17482, -17460, -17458, -17444, -17433, -17427, -17417, -17405, -17395, -17385, -17377, -17373, -17352, -17343, -17332, -17328, -17322, -17314, -17304, -17296, -17294, -17285, -17282, -17276, -17271, -17264, -17256, -17252, -17245, -17242, -17232, -17226, -17221, -17219, -17216, -17212, -17205, -17202, -17187, -17185, -17183, -17177, -17167, -17166, -17158, -17156, -17149, -17145, -17140, -17139, -17128, -17123, -17119, -17118, -17112, -17109, -17097, -17094, -17086, -17084, -17079, -17077, -17073, -17068, -17061, -17058, -17040, -17034, -17027, -17025, -17020, -17014, -17008, -17004, -16999, -16997, -16992, -16985, -16983, -16970, -16969, -16966, -16963, -16958, -16956, -16947, -16943, -16941, -16937, -16934, -16930, -16921, -16919, -16918, -16914, -16908, -16904, -16896, -16891, -16886, -16884, -16878, -16873, -16870, -16866, -16864, -16861, -16858, -16842, -16835, -16833, -16830, -16828, -16824, -16822, -16815, -16812, -16794, -16789, -16779, -16774, -16770, -16766, -16763, -16758, -16756, -16742, -16741, -16734, -16729, -16726, -16722, -16720, -16715, -16711, -16703, -16701, -16698, -16697, -16696, -16689, -16686, -16684, -16681, -16676, -16673, -16672, -16665, -16664, -16657, -16642, -16641, -16637, -16633, -16630, -16628, -16625, -16622, -16618, -16612, -16609, -16607, -16599, -16595, -16585, -16583, -16580, -16579, -16577, -16573, -16572, -16565, -16563, -16559, -16558, -16556, -16546, -16545, -16534, -16529, -16526, -16524, -16519, -16517, -16512, -16506, -16504, -16500, -16499, -16497, -16494, -16486, -16482, -16476, -16473, -16468, -16463, -16453, -16448, -16447, -16443, -16440, -16436, -16434, -16427, -16423, -16419, -16412, -16407, -16403, -16401, -16393, -16391, -16387, -16383, -16373, -16370, -16366, -16364, -16357, -16353, -16345, -16341, -16338, -16334, -16330, -16321, -16315, -16309, -16303, -16292, -16291, -16280, -16276, -16270, -16263, -16261, -16252, -16249, -16243, -16241, -16236, -16233, -16220, -16216, -16212, -16205, -16202, -16187, -16180, -16171, -16169, -16167, -16164, -16158, -16155, -16152, -16149, -16145, -16140, -16139, -16138, -16130, -16121, -16113, -16109, -16103, -16102, -16097, -16094, -16092, -16090, -16087, -16080, -16079, -16077, -16068, -16064, -16061, -16055, -16041, -16040, -16039, -16037, -16036, -16033, -16024, -16019, -16015, -16009, -15996, -15995, -15988, -15987, -15975, -15971, -15968, -15963, -15958, -15956, -15944, -15933, -15920, -15915, -15903, -15889, -15878, -15871, -15862, -15857, -15854, -15848, -15836, -15832, -15824, -15816, -15802, -15799, -15796, -15788, -15782, -15776, -15774, -15763, -15756, -15754, -15748, -15747, -15741, -15739, -15734, -15730, -15721, -15718, -15712, -15701, -15699, -15698, -15697, -15686, -15681, -15676, -15675, -15667, -15666, -15664, -15661, -15659, -15658, -15656, -15654, -15648, -15646, -15645, -15631, -15625, -15621, -15617, -15613, -15611, -15607, -15604, -15603, -15596, -15593, -15591, -15587, -15586, -15584, -15579, -15578, -15577, -15576, -15568, -15565, -15554, -15552, -15549, -15548, -15547, -15544, -15537, -15533, -15528, -15527, -15523, -15520, -15517, -15511, -15507, -15503, -15492, -15490, -15486, -15485, -15479, -15476, -15474, -15469, -15467, -15464, -15459, -15455, -15454, -15451, -15448, -15447, -15440, -15439, -15438, -15436, -15435, -15434, -15433, -15431, -15430, -15429, -15427, -15426, -15423, -15422, -15421, -15413, -15411, -15410, -15408, -15406, -15405, -15398, -15396, -15395, -15384, -15383, -15379, -15375, -15369, -15363, -15362, -15358, -15355, -15352, -15350, -15345, -15344, -15337, -15336, -15335, -15334, -15329, -15328, -15322, -15321, -15320, -15317, -15315, -15314, -15309, -15304, -15301, -15298, -15297, -15295, -15293, -15291, -15290, -15288, -15287, -15282, -15278, -15276, -15275, -15268, -15267, -15264, -15262, -15261, -15260, -15258, -15256, -15254, -15250, -15249, -15248, -15246, -15245, -15243, -15242, -15240, -15239, -15238, -15237, -15236, -15233, -15232, -15231, -15230, -15226, -15225, -15224, -15223, -15222, -15219, -15216, -15214, -15213, -15211, -15210, -15209, -15207, -15206, -15205, -15204, -15202, -15200, -15199, -15196, -15195, -15192, -15191, -15188, -15186, -15184, -15183, -15181, -15180, -15179, -15178, -15177, -15176, -15175, -15174, -15173, -15172, -15170, -15168, -15167, -15166, -15164, -15163, -15161, -15160, -15159, -15158, -15157, -15155, -15153, -15152, -15151, -15150, -15149, -15147, -15146, -15144, -15142, -15141, -15140, -15138, -15137, -15136, -15135, -15134, -15133, -15131, -15130, -15129, -15127, -15126, -15124, -15123, -15121, -15120, -15119, -15118, -15117, -15115, -15114, -15112, -15111, -15109, -15107, -15105, -15103, -15102, -15101, -15100, -15099, -15098, -15097, -15095, -15093, -15091, -15089, -15088, -15087, -15085, -15084, -15082, -15080, -15079, -15077, -15075, -15074, -15072, -15071, -15069, -15067, -15066, -15064, -15062, -15061, -15059, -15057, -15056, -15054, -15053, -15051, -15050, -15048, -15046, -15045, -15043, -15041, -15040, -15038