excel公式汉字转换为大写拼音
第一步：右击要转换首字母的单元格，选择定义名称。第二步：在名称处输入：PY在引用位置处输入： ={"","吖","八","攃","咑","鵽","发","旮","哈","丌","咔","垃","妈","乸","噢","帊","七","冄","仨","他","屲","夕","丫","帀";"","A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}。
第三步：在需转换结果的单元格输入：=LOOKUP(MID(A第二步：,第一步：,第一步：),PY)&LOOKUP(MID(A第二步：,第二步：,第一步：),PY)&LOOKUP(MID(A第二步：,第三步：,第一步：),PY)&LOOKUP(MID(A第二步：,第四步：,第一步：),PY)。
第四步：如图所示，汉字已经转换为首字母拼写。
感谢大家对浓知百科网的支持，相关操作方法来源于网络，本篇内容主要是围绕excel公式汉字转换为大写拼音进行阐述,本文相关关键词还有:用公式将汉字转换成拼音首字母。
绛旓細绗竴姝ワ細鍙冲嚮瑕杞崲棣栧瓧姣嶇殑鍗曞厓鏍硷紝閫夋嫨瀹氫箟鍚嶇О銆傜浜屾锛氬湪鍚嶇О澶勮緭鍏ワ細PY鍦ㄥ紩鐢ㄤ綅缃杈撳叆锛 ={"","鍚","鍏","鏀","鍜","榈","鍙","鏃","鍝","涓","鍜","鍨","濡","涔","鍣","甯","涓","鍐","浠","浠","灞","澶","涓","甯";"","A","B","C","D",...
绛旓細1銆侀鍏堝湪鐢佃剳妗岄潰涓婃墦寮excel鏂囨。銆2銆佺劧鍚庤緭鍏鍏紡鈥滐紳getpy(C2)鈥濄3銆佹鏃跺氨鍑虹幇鎷奸煶浜嗐4銆佹帴鐫閫変腑D2鍗曞厓鏍硷紝鍚戜笅鎷栧姩榧犳爣銆5銆佹墍鏈夊鍚嶉兘鑷姩鐢熸垚鎷奸煶浜嗐6銆佽緭鍏ュ叕寮忊滐紳PROPER(D2)鈥濓紝鎸夊洖杞︾‘璁わ紝鍙互灏嗛瀛楁瘝鏀规垚澶у啓銆7銆佹渶鍚庨瀛楁瘝灏卞彉鎴愬ぇ鍐欎簡銆
绛旓細1銆侀鍏堝湪excel琛ㄦ牸涓緭鍏ヤ竴缁勬暟瀛楋紝闇瑕佹牴鎹叕寮忓皢鍏惰浆鎹负澶у啓銆2銆佸湪绌虹櫧鍗曞厓鏍间腑杈撳叆鍏紡锛=IF(A1<0,"璐","")&IF(ABS(A1)>1,TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"鍏","")& IF(ISERR(FIND(".",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]...
绛旓細鎵闇鏉愭枡锛Excel銆涓枃杞嫾闊棣栧瓧姣澶у啓鍑芥暟銆備竴銆侀鍏堟墦寮Excel锛岀劧鍚庢寜涓婣lt+F11鎵撳紑Viaual Basic缂栬緫鍣紝鐐瑰嚮鎻掑叆锛屼笅鎷夎彍鍗曞唴鐐瑰嚮妯″潡銆備簩銆佹妸鍑嗗濂界殑姹夊瓧杞嫾闊鍑芥暟绮樿创杩涙潵锛岄渶瑕佹敞鎰忕殑鏄紝浠庣綉缁滀笂澶嶅埗鐨勫嚱鏁版瘡涓琛岄兘浼氭湁涓涓洖杞︼紝鍦ㄦā鍧楀唴闇瑕佹妸娈佃惤涔嬮棿鐨勭┖琛屽叏閮ㄦ竻闄わ紝娈佃惤鍓嶉潰鐨勭┖鏍间篃闇瑕佺粰娓呴櫎...
绛旓細1銆侀鍏堝湪鑷繁鐢佃剳涓婏紝鎵撳紑Excel涓浠借〃鏍笺傝繖涓婇潰鐨勫悕瀛楅兘鏄嚜宸辩紪鐨勶紝濡傛灉鍜屼綘鐩稿悓鐨勫悕瀛楃函灞炲阀鍚堛2銆佹垜浠氨鍦ㄦ墦寮鐨勮〃鏍糄1鍗曞厓鏍间笂锛岃緭鍏杞嫾闊鐨姹夊瓧锛岀劧鍚庡湪D2鍗曞厓鏍奸噷杈撳叆=getpy(A2)鍏紡銆傚洜涓哄鍚嶅湪A鍒椾笂锛屾墍浠ラ渶瑕佸紩鐢ㄥ崟鍏冩牸閫夋嫨A2銆3銆佽緭鍏ュ畬鍏紡閫変腑濂藉紩鐢ㄥ悕瀛楃殑鍗曞厓鏍间箣鍚庯紝鎸変笅纭畾閿湪D...
绛旓細姹夊瓧杞寲涓烘嫾闊鐨鍏紡锛氣=getpy(鐩爣鍗曞厓鏍)鈥濄傚伐鍏凤紡鍘熸枡锛氳仈鎯砓7000P Windows10 Excel 2007 1銆侀鍏堢敤office Excel 2007鎵撳紑鏂囨。銆2銆佺劧鍚庨紶鏍囨爣瀹氬湪D2鍗曞厓鏍硷紝杈撳叆鍏紡鈥滐紳getpy(C2)鈥濓紝鎸夊洖杞﹂敭纭銆3銆佹垜浠氨鐪嬪埌濮撳悕涓鏍忔眽璇嫾闊冲氨鑷姩鍑虹幇浜嗐4銆侀変腑D2鍗曞厓鏍硷紝榧犳爣鏀惧湪鍗曞厓鏍煎彸涓嬭锛屽綋...
绛旓細杞崲涓锛氭暟瀛杞眽瀛浜烘皯甯侀噾棰濆綋闈㈠濡備綍鍦Excel涓灏嗘暟瀛杞崲涓哄ぇ鍐浜烘皯甯侀噾棰濇椂锛屽彧闇鍊熷姪 SUBSTITUE 鍜 TEXT 鍑芥暟锛屼竴鍒囪繋鍒冭岃В銆備互0.11涓轰緥锛岃緭鍏鍏紡锛=SUBSTITUTE(SUBSTITUTE(TEXT(A1*100, "[Dbnum2]0瑙0鍒"),"闆惰", ""), "闆跺垎", "")杩欎竴姝ラ灏嗘暟瀛楁牸寮忓寲涓恒屽９瑙掑９鍒嗐嶏紝閬垮厤浜...
绛旓細1銆佹墦寮闇瑕佹搷浣滅殑EXCEL琛ㄦ牸锛屽湪绌虹櫧鍗曞厓鏍间腑杈撳叆鍏紡=TEXT(锛岀劧鍚庣偣鍑婚夋嫨闇瑕佽浆鎹㈢殑鏁板瓧鎵鍦ㄥ崟鍏冩牸鍏1銆2銆佺户缁湪鍑芥暟缂栬緫妗嗚緭鍏"[DBnum2]")&"鍏冩暣"锛屽洖杞﹀畬鎴愬叕寮=TEXT(A1,"[DBnum2]")&"鍏冩暣"鐨勭紪杈戣緭鍏ャ傘愬叾涓瑼1鏄渶瑕佽浆鎹㈢殑鏁板瓧鎵鍦ㄥ崟鍏冩牸锛孾DBnum2]鍒欒〃绀杞崲涓哄ぇ鍐锛屽悗闈㈣嚜鍔ㄥ姞涓娾滃厓鏁...
绛旓細鏂规硶涓 鐢ㄣ怤UMBERSTRING銆鍏紡锛屽锛氬皢F2鍗曞厓鏍肩殑4500杞崲鎴愬ぇ鍐锛屽垯鍦℅2杈撳叆鍏紡 銆=NUMBERSTRING(F2锛2)銆戯紝鐒跺悗鐐瑰嚮绌虹櫧鍗曞厓鏍兼垨鎸夐敭鐩樹笂銆愬洖杞︺戦敭灏辫兘寰楀嚭锛氳倖浠熶紞浣帮紱鏂规硶浜 鍦ㄨ〃鏍间腑杈撳叆鏁板硷紝閫変腑鎯宠杞寲涓哄ぇ鍐鐨勬暟瀛楀崟鍏冩牸锛岄紶鏍囧彸閿夋嫨銆愯缃崟鍏冩牸鏍煎紡銆戯紝鍦ㄥ脊鍑烘潵鐨勮缃璇濇閫夋嫨绗竴鎺...
绛旓細鍦 Excel 涓锛屽彲浠ヤ娇鐢ㄥ嚱鏁板拰鍏紡鏉ュ皢鏂囨湰鑷姩杞崲涓哄ぇ鍐銆備互涓嬫槸涓ょ甯哥敤鐨勬柟娉曪細1. 浣跨敤 UPPER 鍑芥暟 UPPER 鍑芥暟鍙互灏嗘枃鏈浆鎹负澶у啓銆備緥濡傦紝濡傛灉瑕佸皢 A1 鍗曞厓鏍间腑鐨勬枃鏈浆鎹负澶у啓锛屽苟鍦 B1 鍗曞厓鏍间腑鏄剧ず缁撴灉锛屽彲浠ヤ娇鐢ㄤ互涓嬪叕寮忥細=UPPER(A1)杩欏皢浼氬皢 A1 鍗曞厓鏍间腑鐨勬枃鏈浆鎹负澶у啓锛屽苟鍦 B1 鍗曞厓...
