EXCEL中能否直接把中文轉換成拼音

時間 2021-10-14 22:42:59

1樓:克萊文天空

按alt鍵+f11鍵,就會彈出乙個對話方塊,選擇框中的建立模板,然後在模板上編輯自定義函式即可

2樓:勞清涵

可以把中文轉換成拼音的。

3樓:竹本王子

excel**中漢字轉拼音技巧

2011-01-27 20:54:57| 分類:

程式設計office excel | 標籤:pinma pinyin excel temp mypinma |字型大小 訂閱

function pinyin(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

pinyin = pinyin & mypinma(j - 1) & " "

exit for

end if

next

end if

next

pinyin = trim(pinyin)

end function

excel自定義函式方法:

1.啟動excel 2003(其它版本請仿照操作),開啟相應的工作表;

2.執行「工具→巨集→visual basic編輯器」命令(或者直接按「alt+f11」組合鍵),進入visual basic編輯狀態;

3.執行「插入→模組」命令,插入乙個新模組。再雙擊插入的模組,進入模組**編輯狀態;

4.將**輸入其中;

5.**輸入完成後,關閉visual basic編輯視窗,返回excel編輯狀態;

6.自定義函式就可以用了,如:選中d2單元格,輸入公式:=pinyin(a2

Excel中輸入數字如何自動轉換為中文大寫數字

其實excel 強大的自動運算能力,可以輕鬆實現在excel中輸入數字時自動轉換為中文大寫數字。下面。筆者介紹下具體的操作步驟 第一步 開啟excel 工作表,滑鼠右鍵單擊選中需要顯示中文大寫數字的單元格 可以批量拉菜單元格 在彈出的快捷選單中選擇 設定單元格格式 第二步 在彈出的對話方塊中選擇 數...

excel怎麼行列轉換,excel中如何進行行列轉換

玉斧 excel行列如何互換? 溫州甌越培訓學校 excel可以實現行列轉換,具體操作如下 一 使用工具 excel2003 二 操作步驟 1 進入excel2003並選擇需要行列轉換的單元格區域,然後右擊滑鼠選擇 複製 或直接按ctrl c,如圖 2 然後右擊滑鼠,選擇 選擇性貼上 如圖 3 在 ...

Excel中,如何把科學記數法轉換成數字

蟻秋珊庫元 excel中預設數字顯示11位,如果超過11位,則會顯示為科學記數法或後面的顯示為0,二代身份證號是18位,要全部顯示出來,就要以文字格式輸入,方法有 1.右擊單元格 如果是整列,直接右擊列標 設定單元格格式 數字 文字 確定 2.先輸入英文狀態下的單引號 再輸入數字串,也是作為文字,會...