excel怎么把汉字转换成拼音 EXCEL中能否直接把中文转换成拼音？
\u5982\u4f55\u5728excel\u4e2d\u628a\u6c49\u5b57\u8f6c\u6362\u6210\u62fc\u97f3Excel\u5185\u662f\u53ef\u4ee5\u628a\u4e2d\u6587\u8f6c\u6362\u6210\u4e3a\u62fc\u97f3\u7684\uff0c\u4f46\u9700\u8981\u8f6c\u6362\u51fd\u6570\uff08\u51fd\u6570\u53ef\u901a\u8fc7\u7f51\u7edc\u4e0a\u9762\u4e0b\u8f7d\uff09\uff0c\u4e0b\u9762\u7ed9\u51fa\u5177\u4f53\u64cd\u4f5c\u65b9\u6cd5\uff1a
\u6240\u9700\u6750\u6599\uff1aExcel\u3001\u51c6\u5907\u597d\u7684\u4e2d\u6587\u8f6c\u62fc\u97f3\u51fd\u6570\u3002
\u4e00\u3001\u9996\u5148\u6253\u5f00Excel\u8f6f\u4ef6\uff0c\u7136\u540e\u6309Alt+F11\u6253\u5f00Viaual Basic\u7f16\u8f91\u5668\uff0c\u70b9\u51fb\u5de5\u5177\u680f\u201c\u63d2\u5165\u201d\uff0c\u9009\u9879\u5185\u70b9\u51fb\u201c\u6a21\u5757\u201d\u3002
\u4e8c\u3001\u8fd9\u65f6\u628a\u51c6\u5907\u597d\u7684\u4e2d\u6587\u8f6c\u62fc\u97f3\u51fd\u6570\u7c98\u8d34\u5165\u8be5\u6a21\u5757\u4e0b\uff0c\u7136\u540e\u5c31\u53ef\u4ee5\u5173\u95ed\u6389Viaual Basic\u7f16\u8f91\u5668\u3002
\u4e09\u3001\u56de\u5230Excel\u754c\u9762\u5728\u9700\u8981\u8f6c\u6362\u7684\u5355\u5143\u683c\u5185\u8f93\u5165\u4e2d\u6587\u8f6c\u62fc\u97f3\u7684\u516c\u5f0f\uff08\u8fd9\u91cc\u9700\u8981\u6839\u636e\u4e0b\u8f7d\u7684\u51fd\u6570\u6765\u8f93\u5165\u5bf9\u5e94\u7684\u516c\u5f0f\uff0c\u5982\u4e0b\u56fe\u7684\u516c\u5f0f\u4e3a=pinyin\uff0c\u800c\u6709\u4e00\u4e9b\u516c\u5f0f\u5219\u4e3a=getpy\uff0c\u6ce8\u610f\u516c\u5f0f\u4e0d\u8981\u7528\u9519\uff09\uff0c\u6309\u4e0b\u56de\u8f66\u952e\u5373\u53ef\u5f97\u5230\u516c\u5f0f\u5185\u6240\u6c42\u5355\u5143\u683c\u7684\u62fc\u97f3\u3002
\u56db\u3001\u6700\u540e\u6309\u4f4f\u5df2\u8f6c\u6362\u5b8c\u6210\u5355\u5143\u683c\u53f3\u4e0b\u89d2\u5411\u4e0b\u62d6\u52a8\u5373\u53ef\u5f97\u5230\u6574\u5217\u4e2d\u6587\u7684\u62fc\u97f3 \u3002
Excel中可以利用自定义函数来实现将汉字转换成拼音。
所用工具：Office2007
举例说明如下：
1.将A列数据转换成拼音：
2.alt+F11插入模块，在模块中输入如下代码，代码很多（由于篇幅限制，无法将全部代码发上来，可以搜索汉字ASC码来获取），但原理很简单，利用每个汉字的ASC码来得到这个汉字的拼音，然后依次提取单元格中的每一个汉字，分别获得其拼音。
Function pinyin(p As String) As String
i = Asc(p)
Select Case i
Case -20319 To -20318: pinyin = "a "
Case -20317 To -20305: pinyin = "ai "
Case -20304 To -20296: pinyin = "an "
Case -20295 To -20293: pinyin = "ang "
Case -20292 To -20284: pinyin = "ao "
Case -20283 To -20266: pinyin = "ba "
Case -20265 To -20258: pinyin = "bai "
Case -20257 To -20243: pinyin = "ban "
Case -20242 To -20231: pinyin = "bang "
Case -20230 To -20052: pinyin = "bao "
Case -20051 To -20037: pinyin = "bei "
Case -20036 To -20033: pinyin = "ben "
Case -20032 To -20027: pinyin = "beng "
Case -20026 To -20003: pinyin = "bi "
Case -20002 To -19991: pinyin = "bian "
Case -19990 To -19987: pinyin = "biao "
Case -19986 To -19983: pinyin = "bie "
……
Case -11055 To -11053: pinyin = "za "
Case -11052 To -11046: pinyin = "zai "
Case -11045 To -11042: pinyin = "zan "
Case -11041 To -11039: pinyin = "zang "
Case -11038 To -11025: pinyin = "zao "
Case -11024 To -11021: pinyin = "ze "
Case -11020 To -11020: pinyin = "zei "
Case -11019 To -11019: pinyin = "zen "
Case -11018 To -11015: pinyin = "zeng "
Case -11014 To -10839: pinyin = "zha "
Case -10838 To -10833: pinyin = "zhai "
Case -10832 To -10816: pinyin = "zhan "
Case -10815 To -10801: pinyin = "zhang "
Case -10800 To -10791: pinyin = "zhao "
Case -10790 To -10781: pinyin = "zhe "
Case -10780 To -10765: pinyin = "zhen "
Case -10764 To -10588: pinyin = "zheng "
Case -10587 To -10545: pinyin = "zhi "
Case -10544 To -10534: pinyin = "zhong "
Case -10533 To -10520: pinyin = "zhou "
Case -10519 To -10332: pinyin = "zhu "
Case -10331 To -10330: pinyin = "zhua "
Case -10329 To -10329: pinyin = "zhuai "
Case -10328 To -10323: pinyin = "zhuan "
Case -10322 To -10316: pinyin = "zhuang "
Case -10315 To -10310: pinyin = "zhui "
Case -10309 To -10308: pinyin = "zhun "
Case -10307 To -10297: pinyin = "zhuo "
Case -10296 To -10282: pinyin = "zi "
Case -10281 To -10275: pinyin = "zong "
Case -10274 To -10271: pinyin = "zou "
Case -10270 To -10263: pinyin = "zu "
Case -10262 To -10261: pinyin = "zuan "
Case -10260 To -10257: pinyin = "zui "
Case -10256 To -10255: pinyin = "zun "
Case -10254 To -10254: pinyin = "zuo "
Case Else: pinyin = p
End Select
End Function
Function py(str)
For i = 1 To Len(str)
py = py & pinyin(Mid(str, i, 1))
Next i
End Function
3.这样，返回Excel利用自定义的py函数即可：
4.下拉填充，就可以得到全部汉字的拼音：
绛旓細1銆佹垜浠柊寤轰竴涓〃鏍硷紝鍦ㄩ噷闈㈣緭鍏ユ祴璇曟暟鎹紝濡備笅鍥炬墍绀 2銆佹垜浠柊寤轰竴涓猈ord鏂囨。锛屽皢琛ㄦ牸鐨勫唴瀹瑰鍒朵笂鍘 3銆佹垜浠帴鐫鍦╓ord鏂囨。涓紝灏嗗厜鏍囬変腑鍐呭锛屽啀鐐瑰嚮鎷奸煶鎸囧崡 4銆佸脊鍑烘嫾闊虫寚鍗楀璇濇锛屾垜浠偣鍑荤‘瀹氬嵆鍙 5銆佽繖鏃跺欏氨鍙互鐪嬪埌Word鏂囨。涓婇潰鐨勫唴瀹归兘鏈夋嫾闊充簡 6銆佹垜浠啀灏哤ord鐨勫唴瀹瑰鍒跺埌琛ㄦ牸涓紝鎺ョ潃...
绛旓細1銆侀鍏堟墦寮excel琛ㄦ牸锛屽湪閲岄潰杈撳叆涓浜涜嚜宸辫鎷奸煶鐨勬眽瀛楋紝鏈変簺浜哄氨鏄兂鐩存帴鍦ㄨ〃鏍间腑杈撳叆鎷奸煶锛岀劧鍚庣偣鍑诲垪锛岀偣鍑婚紶鏍囧彸閿紝鐒跺悗閫夋嫨澶嶅埗锛岃繖鏃跺欏氨澶嶅埗濂戒簡锛岀劧鍚庢墦寮word鏂囨。锛屽皢澶嶅埗鍐呭榛忚创杩涙潵鍗冲彲銆2銆佹帴鐫鐐瑰嚮寮濮嬪锛岀劧鍚庢壘鍒版嫾闊虫寚鍗楋紝濡傚浘鎵绀烘槸涓涓枃瀛楋紝杩樻湁鎷奸煶鐨勭鍙凤紝鐩存帴鐐瑰嚮杩欎釜鍗冲彲銆3銆佺劧鍚...
绛旓細1銆侀鍏堬紝鎵撳紑瑕杞崲鎴愭嫾闊鐨excel琛ㄦ牸銆2銆佹寜鈥淎lt+F11鈥濈粍鍚堥敭锛岃繘鍏isual Basic缂栬緫鐘舵侊紝涔熷氨鏄湅鍒扮殑杩欎釜鐏拌壊鐨勭紪杈戠晫闈3銆佹墽琛屸滄彃鍏モ啋妯″潡鈥濆懡浠わ紝鎻掑叆涓涓柊妯″潡銆傚啀鍙屽嚮鎻掑叆鐨勬ā鍧楋紝杩涘叆妯″潡浠ｇ爜缂栬緫鐘舵併4銆佺湅鍒扮┖鐧界晫闈㈠悗锛屽皢涓嬮潰鐨勬墍鏈夊唴瀹瑰鍒讹紝绮樿创鍒扮┖鐧藉銆5銆佹寜涓婣LT+Q鍏抽棴Visual ...
绛旓細1. 棣栧厛锛屽湪WPS Excel涓墦寮浣犻渶瑕佽浆鎹㈡嫾闊崇殑琛ㄦ牸銆2. 閫変腑鍖呭惈姹夊瓧鐨勫崟鍏冩牸鎴栧尯鍩熴備綘鍙互閫氳繃榧犳爣鐐瑰嚮骞舵嫋鎷芥潵閫夋嫨澶氫釜鍗曞厓鏍笺3. 鍦╓PS Excel鐨勮彍鍗曟爮涓紝鎵惧埌鈥滃紑濮嬧濋夐」鍗★紝骞剁偣鍑烩滄嫾闊虫寚鍗椻濇寜閽傝繖涓寜閽氬父浣嶄簬鈥滃瓧浣撯濈粍鐨勫彸涓嬭銆4. 鍦ㄥ脊鍑虹殑鈥滄嫾闊虫寚鍗椻濆璇濇涓紝浣犲彲浠ョ湅鍒伴夊畾鐨勬眽...
绛旓細1.棣栧厛鐢╫ffice Excel 2007鎵撳紑鏂囨。;2.鐒跺悗榧犳爣鏍囧畾鍦―2鍗曞厓鏍硷紝杈撳叆鍏紡鈥=getpy(C2)鈥濓紝鎸夊洖杞﹂敭纭;3.鎴戜滑灏辩湅鍒板鍚嶄竴鏍忔眽璇嫾闊冲氨鑷姩鍑虹幇浜;4.閫変腑D2鍗曞厓鏍硷紝榧犳爣鏀惧湪鍗曞厓鏍煎彸涓嬭,褰撳嚭鐜扳+鈥濆悗锛屽悜涓嬫嫋鍔ㄩ紶鏍;5.杩欐牱锛屽鍚嶄竴鏍忔墍鏈夌殑姹夊瓧閮戒互鎷奸煶褰㈠紡鏄剧ず浜;6.濡傛灉鎴戜滑闇瑕佸皢鎷奸煶鐨勯瀛楁瘝...
绛旓細涓嬮潰鎴戜滑灏辨潵鐪嬬湅鍦excel涓槸濡備綍灏嗗鍚嶈浆涓烘嫾闊崇殑鍚с1銆佹墦寮excel鎴戜滑鍦ㄩ夋嫨鐨勫崟鍏冩牸鍐呰緭鍏ラ渶瑕佺殑鏂囧瓧锛2銆佽緭鍏ユ枃瀛椾箣鍚庢垜浠夋嫨鍗曞厓鏍硷紝鐒跺悗鍦ㄩ夋嫨鐨勮繖涓崟鍏冩牸鍐呰緭鍏ュ嚱鏁帮紝3銆佽緭鍏ュソ鍑芥暟涔嬪悗鎴戜滑鍦ㄥ嚱鏁扮殑鎷彿鍐呰緭鍏ュ嚱鏁扮殑鍙傛暟锛4銆佽緭鍏ュソ鍑芥暟鐨勫弬鏁颁箣鍚庯紝鎸変笅鍥炶溅閿彲浠ョ湅鍒版枃瀛楀氨琚浆鎴愭嫾闊浜嗭紝
绛旓細1銆侀鍏堟槸鎵撳紑Excel杞欢锛屽湪鍏朵腑娣诲姞涓浜涙眽瀛楀唴瀹癸紝濡備笅鍥炬墍绀 2銆佹帴涓嬫潵鍦–2鍗曞厓鏍艰緭鍏ュ叕寮廹etpy锛屾嫭鍙烽噷闈㈢殑鍙傛暟鏄眽瀛楃殑鍗曞厓鏍间綅缃紝濡備笅鍥炬墍绀 3銆佽緭鍏ュ畬鍏紡浠ュ悗鎸塃nter閿氨鍙互寰楀埌瀵瑰簲鐨姹夊瓧鎷奸煶浜嗭紝濡備笅鍥炬墍绀 4銆佹寜浣廋2鍗曞厓鏍煎彸涓嬭鍚戜笅鎷栨嫿灏卞彲浠ュ緱鍒版墍鏈夋眽瀛楃殑鎷奸煶浜嗭紝濡備笅鍥炬墍绀 宸ュ叿/鏉愭枡 ...
绛旓細1銆侀鍏堝湪鑷繁鐢佃剳涓婏紝鎵撳紑Excel涓浠借〃鏍笺2銆佹垜浠氨鍦ㄦ墦寮鐨勮〃鏍糄1鍗曞厓鏍间笂锛岃緭鍏ヨ浆鎷奸煶鐨姹夊瓧锛岀劧鍚庡湪D2鍗曞厓鏍奸噷杈撳叆=getpy(A2)鍏紡銆傚洜涓哄鍚嶅湪A鍒椾笂锛屾墍浠ラ渶瑕佸紩鐢ㄥ崟鍏冩牸閫夋嫨A2銆3銆佽緭鍏ュ畬鍏紡閫変腑濂藉紩鐢ㄥ悕瀛楃殑鍗曞厓鏍间箣鍚庯紝鎸変笅纭畾閿湪D2鍗曞厓鏍煎氨鍙互鐪嬪埌濮撳悕宸茬粡杞崲鎴愭嫾闊浜嗐4銆佺劧鍚庨変腑D2...
绛旓細1銆佸湪浣跨敤excel琛ㄦ牸鐨勬椂鍊欙紝涓嶈闅忔剰鐨勬寜enter鍜岀┖鐧介敭銆2銆佽鍠勪簬鍒╃敤excel琛ㄦ牸閲岄潰鐨勫揩鎹烽敭锛岃繘琛宔xcel琛ㄦ牸鐨勭紪杈戙3銆佸湪浣跨敤excel琛ㄦ牸鐨勬椂鍊欙紝涓瀹氳瀹氭椂鐨勮繘琛屼繚瀛樸4銆佸湪浣跨敤excel琛ㄦ牸鐨勬椂鍊欙紝涓鏃︽湁涓嶆噦鐨勯棶棰橈紝涓瀹氳鍙婃椂鐨勫悜涓撲笟浜哄憳杩涜鍜ㄨ銆傦級銆傜幇鍦ㄤ綘宸茬粡鎺屾彙浜嗗湪Excel涓嚜鍔ㄧ敓鎴鎷奸煶鐨勬柟娉曪紝...
绛旓細鍏蜂綋濡備笅锛1. 绗竴姝ワ紝鍙屽嚮鎴栬呭彸鍑绘墦寮闇瑕佽繘琛杞崲鐨Excel鏂囨。銆2. 绗簩姝ワ紝閫変腑鎵鏈夐渶瑕佽浆鎹㈢殑瀛楋紝鎺ョ潃鍙冲嚮锛岀偣鍑诲鍒堕夐」锛屾帴鐫鎵撳紑Word杞欢锛岃繘琛岀矘璐达紝鍦ㄧ矘璐存椂闇瑕侀夋嫨鈥滃彧淇濈暀鏂囨湰鈥濋夐」銆3. 绗笁姝ワ紝鍏ㄩ塛ord鏂囨。涓殑鏂囧瓧锛屾帴鐫鐐瑰嚮瀛椾綋椤甸潰涓殑鈥鎷奸煶鎸囧崡鈥濋夐」锛屽湪涓嬪浘鎵绀虹殑鎷奸煶鎸囧崡绐楀彛涓...
