excel姓名轉(zhuǎn)換拼音公式？ EXCEL中能否直接把中文轉(zhuǎn)換成拼音？
概述：在工作時(shí)，有時(shí)候會(huì)用到漢語(yǔ)拼音，本文講述如何在Excel中通過(guò)vba程序提取漢字的拼音。
1、alt+F11調(diào)出vba編寫(xiě)窗口
2、新建——模塊
3、粘貼以下代碼
Function PinYin2(Hz As String)
Dim PinMa As String
Dim MyPinMa As Variant
Dim Temp As Integer, i As Integer, j As Integer
PinMa = "a,20319,ai,20317,an,20304,ang,20295,ao,20292,"
PinMa = PinMa & "ba,20283,bai,20265,ban,20257,bang,20242,bao,20230,bei,20051,ben,20036,beng,20032,bi,20026,bian,20002,biao,19990,bie,19986,bin,19982,bing,19976,bo,19805,bu,19784,"
PinMa = PinMa & "ca,19775,cai,19774,can,19763,cang,19756,cao,19751,ce,19746,ceng,19741,cha,19739,chai,19728,chan,19725,chang,19715,chao,19540,che,19531,chen,19525,cheng,19515,chi,19500,chong,19484,chou,19479,chu,19467,chuai,19289,chuan,19288,chuang,19281,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,cou,19243,cu,19242,cuan,19238,cui,19235,cun,19227,cuo,19224,"
PinMa = PinMa & "da,19218,dai,19212,dan,19038,dang,19023,dao,19018,de,19006,deng,19003,di,18996,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,18773,dou,18763,du,18756,duan,18741,dui,18735,dun,18731,duo,18722,"
PinMa = PinMa & "e,18710,en,18697,er,18696,"
PinMa = PinMa & "fa,18526,fan,18518,fang,18501,fei,18490,fen,18478,feng,18463,fo,18448,fou,18447,fu,18446,"
PinMa = PinMa & "ga,18239,gai,18237,gan,18231,gang,18220,gao,18211,ge,18201,gei,18184,gen,18183,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,17964,guan,17961,guang,17950,gui,17947,gun,17931,guo,17928,"
PinMa = PinMa & "ha,17922,hai,17759,han,17752,hang,17733,hao,17730,he,17721,hei,17703,hen,17701,heng,17697,hong,17692,hou,17683,hu,17676,hua,17496,huai,17487,huan,17482,huang,17468,hui,17454,hun,17433,huo,17427,"
PinMa = PinMa & "ji,17417,jia,17202,jian,17185,jiang,16983,jiao,16970,jie,16942,jin,16915,jing,16733,jiong,16708,jiu,16706,ju,16689,juan,16664,jue,16657,jun,16647,"
PinMa = PinMa & "ka,16474,kai,16470,kan,16465,kang,16459,kao,16452,ke,16448,ken,16433,keng,16429,kong,16427,kou,16423,ku,16419,kua,16412,kuai,16407,kuan,16403,kuang,16401,kui,16393,kun,16220,kuo,16216,"
PinMa = PinMa & "la,16212,lai,16205,lan,16202,lang,16187,lao,16180,le,16171,lei,16169,leng,16158,li,16155,lia,15959,lian,15958,liang,15944,liao,15933,lie,15920,lin,15915,ling,15903,liu,15889,long,15878,lou,15707,lu,15701,lv,15681,luan,15667,lue,15661,lun,15659,luo,15652,"
PinMa = PinMa & "ma,15640,mai,15631,man,15625,mang,15454,mao,15448,me,15436,mei,15435,men,15419,meng,15416,mi,15408,mian,15394,miao,15385,mie,15377,min,15375,ming,15369,miu,15363,mo,15362,mou,15183,mu,15180,"
PinMa = PinMa & "na,15165,nai,15158,nan,15153,nang,15150,nao,15149,ne,15144,nei,15143,nen,15141,neng,15140,ni,15139,nian,15128,niang,15121,niao,15119,nie,15117,nin,15110,ning,15109,niu,14941,nong,14937,nu,14933,nv,14930,nuan,14929,nue,14928,nuo,14926,"
PinMa = PinMa & "o,14922,ou,14921,"
PinMa = PinMa & "pa,14914,pai,14908,pan,14902,pang,14894,pao,14889,pei,14882,pen,14873,peng,14871,pi,14857,pian,14678,piao,14674,pie,14670,pin,14668,ping,14663,po,14654,pu,14645,"
PinMa = PinMa & "qi,14630,qia,14594,qian,14429,qiang,14407,qiao,14399,qie,14384,qin,14379,qing,14368,qiong,14355,qiu,14353,qu,14345,quan,14170,que,14159,qun,14151,"
PinMa = PinMa & "ran,14149,rang,14145,rao,14140,re,14137,ren,14135,reng,14125,ri,14123,rong,14122,rou,14112,ru,14109,ruan,14099,rui,14097,run,14094,ruo,14092,"
PinMa = PinMa & "sa,14090,sai,14087,san,14083,sang,13917,sao,13914,se,13910,sen,13907,seng,13906,sha,13905,shai,13896,shan,13894,shang,13878,shao,13870,she,13859,shen,13847,sheng,13831,shi,13658,shou,13611,shu,13601,shua,13406,shuai,13404,shuan,13400,shuang,13398,shui,13395,shun,13391,shuo,13387,si,13383,song,13367,sou,13359,su,13356,suan,13343,sui,13340,sun,13329,suo,13326,"
PinMa = PinMa & "ta,13318,tai,13147,tan,13138,tang,13120,tao,13107,te,13096,teng,13095,ti,13091,tian,13076,tiao,13068,tie,13063,ting,13060,tong,12888,tou,12875,tu,12871,tuan,12860,tui,12858,tun,12852,tuo,12849,"
PinMa = PinMa & "wa,12838,wai,12831,wan,12829,wang,12812,wei,12802,wen,12607,weng,12597,wo,12594,wu,12585,"
PinMa = PinMa & "xi,12556,xia,12359,xian,12346,xiang,12320,xiao,12300,xie,12120,xin,12099,xing,12089,xiong,12074,xiu,12067,xu,12058,xuan,12039,xue,11867,xun,11861,"
PinMa = PinMa & "ya,11847,yan,11831,yang,11798,yao,11781,ye,11604,yi,11589,yin,11536,ying,11358,yo,11340,yong,11339,you,11324,yu,11303,yuan,11097,yue,11077,yun,11067,"
PinMa = PinMa & "za,11055,zai,11052,zan,11045,zang,11041,zao,11038,ze,11024,zei,11020,zen,11019,zeng,11018,zha,11014,zhai,10838,zhan,10832,zhang,10815,zhao,10800,zhe,10790,zhen,10780,zheng,10764,zhi,10587,zhong,10544,zhou,10533,zhu,10519,zhua,10331,zhuai,10329,zhuan,10328,zhuang,10322,zhui,10315,zhun,10309,zhuo,10307,zi,10296,zong,10281,zou,10274,zu,10270,zuan,10262,zui,10260,zun,10256,zuo,10254"
MyPinMa = Split(PinMa, ",")
For i = 1 To Len(Hz)
Temp = Asc(Mid(Hz, i, 1))
If Temp < 0 Then
Temp = Abs(Temp)
For j = 791 To 1 Step -2
If Temp <= Val(MyPinMa(j)) Then
PinYin2 = PinYin2 & MyPinMa(j - 1) & ""
Exit For
End If
Next
End If
Next
PinYin2 = Trim(PinYin2)End Function
說(shuō)明：代碼來(lái)自網(wǎng)絡(luò)
4、關(guān)閉VBA窗口，調(diào)用
在cell中輸入下面公式即可。
5、完成后，效果如下：
Excel怎么把姓名轉(zhuǎn)換成拼音
下面我們就來(lái)看看在excel中是如何將姓名轉(zhuǎn)為拼音的吧。1、打開(kāi)excel我們?cè)谶x擇的單元格內(nèi)輸入需要的文字，2、輸入文字之后我們選擇單元格，然后在選擇的這個(gè)單元格內(nèi)輸入函數(shù)，3、輸入好函數(shù)之后我們?cè)诤瘮?shù)的括號(hào)內(nèi)輸入函數(shù)的參數(shù)，4、輸入好函數(shù)的參數(shù)之后，按下回車(chē)鍵可以看到文字就被轉(zhuǎn)成拼音了，
怎么把姓名變成大寫(xiě)的拼音?
步驟如下：1.鼠標(biāo)定在C2單元格中，輸入公式“=getpy(B2)”，敲回車(chē)確認(rèn)，如圖所示：2.選中C2單元格，鼠標(biāo)放在單元格右下角出現(xiàn)“+”后，向下拖動(dòng)鼠標(biāo)。如圖：3.這時(shí)候所有人的姓名都以漢語(yǔ)拼音形式顯示了。4.光標(biāo)定在D2單元格中，輸入公式“=PROPER(C2)”，敲回車(chē)確認(rèn)。我們看到唐僧的姓名拼音就...
怎樣在EXCEL中自動(dòng)生成拼音
1、首先在電腦桌面上打開(kāi)excel文檔。2、然后輸入公式“=getpy(C2)”。3、此時(shí)就出現(xiàn)拼音了。4、接著選中D2單元格，向下拖動(dòng)鼠標(biāo)。5、所有姓名都自動(dòng)生成拼音了。6、輸入公式“=PROPER(D2)”，按回車(chē)確認(rèn)，可以將首字母改成大寫(xiě)。7、最后首字母就變成大寫(xiě)了。注意事項(xiàng)：1、在使用excel表格的時(shí)候，不...
excel中的漢字怎么轉(zhuǎn)換為拼音?
excel漢字轉(zhuǎn)拼音不帶聲調(diào)步驟如下：1、從excel復(fù)制人名到word，鼠標(biāo)全選漢字，通過(guò)Ctrl+C快捷鍵復(fù)制，無(wú)格式黏貼到word。2、使用Word中字體菜單里的“拼音指南”功能，點(diǎn)擊確定。3、復(fù)制word中拼音，通過(guò)Ctrl+V快捷鍵粘貼到excel。4、利用Phonetic函數(shù)提取單元格中的拼音，在C1單元格輸入=Phonetic（B1），...
在EXCEL表格里名稱(chēng)如何自動(dòng)生成拼音簡(jiǎn)碼?
接下來(lái)，可以新建一個(gè)工作表。在新的工作表中，A列用于輸入需要轉(zhuǎn)換的漢字，B列用于輸出對(duì)應(yīng)的拼音。在B2單元格中輸入公式“=VLOOKUP(A2,Sheet2!A:B,2,0)”。然后，通過(guò)拖拽填充柄，將此公式應(yīng)用到所有需要轉(zhuǎn)換的漢字單元格中。這樣，所有漢字對(duì)應(yīng)的拼音將自動(dòng)填充到B列中，完成拼音簡(jiǎn)碼的生成。通...
excel姓名轉(zhuǎn)換拼音公式?
1))If Temp < 0 ThenTemp = Abs(Temp)For j = 791 To 1 Step -2If Temp <= Val(MyPinMa(j)) ThenPinYin2 = PinYin2 & MyPinMa(j - 1) & ""Exit ForEnd IfNextEnd IfNextPinYin2 = Trim(PinYin2)End Function說(shuō)明：代碼來(lái)自網(wǎng)絡(luò) 4、關(guān)閉VBA窗口，調(diào)用 在cell中輸入下面公式即可。
怎么把excel表格中的姓名拼音liu\/kun快速換成姓l(shuí)iu名kun
可以使用公式：="姓"&LEFT(A1,FIND("\/",A1)-1)&"名"&RIGHT(A1,LEN(A1)-FIND("\/",A1))如下圖：
wps表格漢字轉(zhuǎn)拼音如何用excel將漢字轉(zhuǎn)化成拼音
wps表格漢字轉(zhuǎn)拼音如何用excel將漢字轉(zhuǎn)化成拼音今天給大家介紹的是EXCEL的一個(gè)很有趣的功能,跟拼音有很大的關(guān)系,那就是在工作表中把漢字轉(zhuǎn)換成為拼音。首先給大家介紹第一個(gè)方法就是通過(guò)VBA函數(shù)進(jìn)行轉(zhuǎn)換。具體步驟
找個(gè)靠譜的excel漢字轉(zhuǎn)換拼音方法?
wps文字，可以加上拼音，再拷到excel來(lái)。如果只有這5個(gè)字，可以公式取拼音 D7公式：=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C7,MID(B7,1,1),""),MID(B7,2,1),""),MID(B7,3,1),""),MID(B7,4,1),""),MID(B7,5,1),""),"("," "),"...
excel怎么將漢字轉(zhuǎn)換成拼音
計(jì)算排名取消撤銷(xiāo)設(shè)置排名進(jìn)行共享制作表格制作條形碼制作考勤表插入背景圖添加下劃線使用宏命令制作排班表插入分頁(yè)符顯示平滑曲線插入柱狀圖使用四舍五入快速下拉公式進(jìn)行批量求和更換表格樣式使用減法函數(shù)恢復(fù)未保存內(nèi)容制作對(duì)數(shù)圖表制作復(fù)合餅圖數(shù)據(jù)進(jìn)行篩選快速合并單元格推送excel文件多條件篩選功能將數(shù)據(jù)按筆畫(huà)排序...
相關(guān)評(píng)說(shuō)：
旌德縣撤面： ______ 1.先在Word中輸入漢字,格式-中文版式,得到拼音,再粘貼到Excel中A1單元格 2.B1公式=Phonetic(A1),提取拼音
旌德縣撤面： ______ 請(qǐng)到此處 http://www.excelba.com/Soft/Html/121.html下載《漢字轉(zhuǎn)換為拼音》加載宏 也可以用函數(shù)公式直接寫(xiě)出,比如寫(xiě)出4個(gè)漢字的首字母 =LOOKUP(LEFT(A1),{＂＂,＂＂;＂吖＂,＂A＂;＂八＂,＂B＂;＂嚓＂,＂C＂;＂咑＂,＂D...
旌德縣撤面： ______ 只能轉(zhuǎn)換為縮寫(xiě) 看下我其他的回答
旌德縣撤面： ______ 在EXECL中 ,按ALT+F11,插入---模塊 復(fù)制下列代碼 : Function hztopy(hzpy As String) As String Dim hzstring As String, pystring As String Dim hzpysum As Integer, hzi As Integer, hzpyhex As Integer hzstring = Trim(hzpy) hzpysum = Len(Trim(...
旌德縣撤面： ______ 用查找和替換功能,只要四次替換就可以了,注意,替換時(shí),一定要展開(kāi)“選項(xiàng)”,把里面的“單元格匹配”前的勾打上.用1替換 “小學(xué)”(不要引號(hào))
旌德縣撤面： ______ 已發(fā)送,注意查收!另外:這個(gè)只能轉(zhuǎn)換一級(jí)字庫(kù)的漢字.如果需要轉(zhuǎn)換其他的話,需要修改.需要運(yùn)行宏.代碼你可以進(jìn)VB編輯器里面看看.現(xiàn)在是在A列輸入,B列輸出大寫(xiě)拼音.需要修改的可以到編輯器去修改.有問(wèn)題繼續(xù)追問(wèn).
旌德縣撤面： ______ 這里有你的答案:http://wenwen.sogou.com/z/q860492158.htm
旌德縣撤面： ______ 「姓名測(cè)試戀愛(ài)匹配度」:如何用名字測(cè)試你和TA的情感契合?在我們的生活中,總有一些人會(huì)讓我們特別心動(dòng),但是我們又不確定我們是否和TA的情感契合度足夠高....
旌德縣撤面： ______ 1. 公式為: =RIGHT(A1,LEN(A1)-LEN(B1)) 2. 如下圖所示:
旌德縣撤面： ______ Excel中好像沒(méi)這個(gè)轉(zhuǎn)換漢字為拼音的公式,應(yīng)該是通過(guò)外加的增強(qiáng)插件做的,沒(méi)有那個(gè)插件,可能是不好改的
