EXCEL里怎么把拼音替换成汉字 excel怎么把汉字转换成拼音
\u5982\u4f55\u5728excel\u4e2d\u628a\u6c49\u5b57\u8f6c\u6362\u6210\u62fc\u97f3Excel\u4e2d\u53ef\u4ee5\u5229\u7528\u81ea\u5b9a\u4e49\u51fd\u6570\u6765\u5b9e\u73b0\u5c06\u6c49\u5b57\u8f6c\u6362\u6210\u62fc\u97f3\u3002
\u6240\u7528\u5de5\u5177\uff1aOffice2007
\u4e3e\u4f8b\u8bf4\u660e\u5982\u4e0b\uff1a
1.\u5c06A\u5217\u6570\u636e\u8f6c\u6362\u6210\u62fc\u97f3\uff1a
2.alt+F11\u63d2\u5165\u6a21\u5757\uff0c\u5728\u6a21\u5757\u4e2d\u8f93\u5165\u5982\u4e0b\u4ee3\u7801\uff0c\u4ee3\u7801\u5f88\u591a\uff08\u7531\u4e8e\u7bc7\u5e45\u9650\u5236\uff0c\u65e0\u6cd5\u5c06\u5168\u90e8\u4ee3\u7801\u53d1\u4e0a\u6765\uff0c\u53ef\u4ee5\u641c\u7d22\u6c49\u5b57ASC\u7801\u6765\u83b7\u53d6\uff09\uff0c\u4f46\u539f\u7406\u5f88\u7b80\u5355\uff0c\u5229\u7528\u6bcf\u4e2a\u6c49\u5b57\u7684ASC\u7801\u6765\u5f97\u5230\u8fd9\u4e2a\u6c49\u5b57\u7684\u62fc\u97f3\uff0c\u7136\u540e\u4f9d\u6b21\u63d0\u53d6\u5355\u5143\u683c\u4e2d\u7684\u6bcf\u4e00\u4e2a\u6c49\u5b57\uff0c\u5206\u522b\u83b7\u5f97\u5176\u62fc\u97f3\u3002
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 "
\u2026\u2026
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.\u8fd9\u6837\uff0c\u8fd4\u56deExcel\u5229\u7528\u81ea\u5b9a\u4e49\u7684py\u51fd\u6570\u5373\u53ef\uff1a
4.\u4e0b\u62c9\u586b\u5145\uff0c\u5c31\u53ef\u4ee5\u5f97\u5230\u5168\u90e8\u6c49\u5b57\u7684\u62fc\u97f3\uff1a
快捷键ctrl+H，如果你是要把多个不同的拼音的话换成汉字的话...也许只能手动...
绛旓細鍙互涓撳尯鍏紡鐨勫尯鍩熸寜F9锛屽彲浠ュ皢鍏紡鏇挎崲涓哄鐓ц〃 濡傛灉杞崲鎷奸煶鐨勬槸澶氫釜瀛楋紝灏辫鍏堟埅鍙栵紝杞嫾闊筹紝鐒跺悗鐢&杩炴帴銆傚洜涓哄鍚嶆湁2涓笌3涓瓧涔嬪垎锛屾墍浠ュ湪鏈夌涓変釜瀛楁椂闇瑕佹坊鍔營F鍑芥暟鏉ュ垽鏂枃鏈暱搴︺傚綋鐒朵篃鍙互鐢ㄤ互涓嬪叕寮 =LOOKUP(D3,A$2:B$24)鏇村Excel鏁欑▼锛岃鐐瑰嚮浜嗚В鏇村 ...
绛旓細鏂规硶涓锛氭牴鎹綘鐨勮〃鏍硷紝鐐逛笅绗洓涓眽锛屽崟鍏冩牸鍙充笅瑙掍細鏈変釜灏忛粦鐐癸紝鍙屽嚮瀹冧細鑷姩鍚戜笅濉厖锛涙柟娉曚簩锛氱偣涓涓嬬涓涓兂瑕佽緭鍏ユ眽鐨勫崟鍏冩牸锛岀劧鍚庢壘鍒版渶鍚庝竴涓紝鎸変綇SHIFT閿紝鐐逛笅鏈鍚庝竴涓崟鍏冩牸锛屽氨浼氶変腑鎵鏈夋兂杈撳叆鐨勫崟鍏冩牸銆傜劧鍚庢墦瀛楄緭鍏モ滄眽鈥濓紝杩欓噷娉ㄦ剰涓嬶紝鎵撳瓧缁撴潫鍚庝笉瑕佹寜ENTER锛岃屾槸鎸変綇CTRL閿啀鎸塃NT...
绛旓細杩欎釜涓嶅ソ瀹炵幇锛屽悓涓涓鎷奸煶鑳藉嚭鏉ヤ笉灏戝瓧锛屾墍浠ュ氨涓嶇煡閬撹浆鎹㈡垚鍝釜瀛椼
绛旓細1. 閫変腑闇瑕佽缃殑鍗曞厓鏍兼垨鍗曞厓鏍煎尯鍩熴2. 鍙抽敭鍗曞嚮閫変腑鐨勫崟鍏冩牸鎴栧崟鍏冩牸鍖哄煙锛岄夋嫨鈥滄牸寮忓崟鍏冩牸鈥銆3. 鍦ㄢ滄牸寮忓崟鍏冩牸鈥濆璇濇涓紝閫夋嫨鈥滄暟瀛椻濋夐」鍗°4. 鍦ㄢ滄暟瀛椻濋夐」鍗′腑锛岄夋嫨闇瑕佺殑鏁板瓧鏍煎紡锛屽苟璁剧疆鐩稿簲鐨勫瓧浣撳拰瀛楀彿銆5. 鐐瑰嚮鈥滅‘瀹氣濅繚瀛樿缃6. 鍐嶆鍙抽敭鍗曞嚮閫変腑鐨勫崟鍏冩牸鎴栧崟鍏冩牸鍖哄煙锛...
绛旓細閫変腑鍐呭---鏍煎紡---鎷奸煶鎸囧崡 浣嗭紝鍦‥XCEL涓锛岀敤璧锋潵涓嶅word 涓柟渚匡紝鍙互鍦╳ord涓舰鎴愶紝鍐嶇矘璐村埌鍒殑鍦版柟锛屽绮樿创鍒癊XCEL涓傚(r煤)浣(h茅)灏(ji膩ng)EXCEL琛(bi菐o)鏍(g茅)涓(zh艒ng)鐨(de)姹(h脿n)瀛(z矛)杞(zhu菐n)涓(w茅i)鎷(p墨n)闊(y墨n)---杩欐槸鍦╳ord涓舰鎴愮殑锛屼絾锛屽湪word ...
绛旓細濡傛灉鏄釜鍒崟璇嶅ソ璇达紝鐩存帴浣跨敤鏇挎崲鍔熻兘鍗冲彲鏇挎崲鎴涓枃 濡傛灉鏄ぇ閲忕殑鑻辨枃鏂囩珷鍗曡瘝涔嬬被鐨勶紝閭ｄ箞灏遍渶瑕佹湁涓嫳鏂囧搴斾腑鏂囧簱 浣跨敤vba杩涜閬嶅巻鏇挎崲銆傚叿浣撹繕鏄湅妤间富鐨勮〃鏍煎唴瀹瑰強鍏蜂綋瑕佹眰浜
绛旓細姝ラ1銆佺涓姝ュ氨鏄墦寮Excel宸ヤ綔琛紝閫変腑涓涓渶瑕佽繘琛鎷奸煶鏍囨敞鐨勫崟鍏冩牸锛屼箣鍚庡崟鍑烩滃紑濮嬮夐」鍗★紝鍦ㄢ滃瓧浣撻夐」缁勪腑鍗曞嚮鈥滄樉绀烘垨闅愯棌鎷奸煶瀛楁鐨勫浘鏍囦笅鎷夋寜閽紝鍦ㄥ脊鍑虹殑涓嬫媺鑿滃崟涓夋嫨鈥滅紪杈戞嫾闊冲懡浠わ紝涓嬪浘绾㈣壊鏂规鏍囪瘑澶勶紱2銆佷箣鍚庝綘浼氱湅鍒板湪閫変腑鍗曞厓鏍肩殑涓婃柟浼氬嚭鐜颁竴涓枃鏈锛屾帴鐫鍦ㄩ噷闈㈤敭鍏ユ嫾闊冲瓧姣嶏紝鏄粈涔...
绛旓細澶嶅埗--绮樿创锛堥夋嫨鎬х矘璐存椂閫夋嫨鍊硷級
绛旓細濡傛灉瑕佺敤涓涓叕寮忓畬鎴愭搷浣滐紝鍙湁鍔犱竴鍒楁瘮濡侰鍒楋細C1杈撳叆鈥滃ソ鈥濓紝C2杈撳叆鈥滄眽鈥濓紝C3杈撳叆鈥滄瓕鈥濃︹1杈撳叆鍏紡锛=SUBSTITUTE(A1,INDIRECT("C"&INT((ROW(A1)-1)/10)+1),INDIRECT("B"&INT((ROW(A1)-1)/10)+1))鍚戜笅濉厖銆
绛旓細杩欐槸鍥犱负浠栦汉涓杩欏紶琛ㄨ缃簡鏁版嵁鏈夋晥鎬э紝濡傛灉杩欎竴鍒楀氨鏄敤鏉ヨ緭鍏ユ皯鏃忕殑锛屼綘鐐逛竴涓嬭繖涓崟鍏冩牸锛屽湪鍙宠竟濡傛灉鏈変竴涓笅鎷夌澶达紝浣犲氨搴旇鍦ㄤ笅鎷夊垪琛ㄤ腑閫夋嫨锛涘鏋滀笉鏄笓闂ㄧ敤浜庤緭鍏ユ皯鏃忕殑锛岃繖鏈夊彲鑳芥槸璁剧疆浜嗘湁鏁堟э紝涓庝綘杈撳叆鐨勫唴瀹逛笉涓鑷撮犳垚鐨勩傚鐞嗘柟娉曪細鏁版嵁鈥斺旀湁鏁堟р斺旇缃紝鍦ㄨ缃璇濇涓崟鍑讳笅闈㈢殑...
