excel怎樣導出漢字的拼音

『貳』 excel中如何實現提取漢字的拼音首字母

步驟一：將下述常量數組定義為名稱，如PY，下面就是包括26個字母及其第一個漢字： ={"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"發","F";"猤","G";"鉿","H";" 夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";" 仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}
復制公式或代碼步驟二：使用LOOKUP(漢字,PY)或者VLOOKUP(漢字,PY,2)就可以返回指定漢字的拼音首字母：
（注意：使用VLOOKUP()函數時，其最後一個參數須用1或True的模糊「默認」查找方式）

如下，LOOKUP()的個數可根據漢字的個數決定，由於上面定義的PY最前面有一個""的值，所以可以屏蔽錯誤，當然也可以用迭代計算的方式獲得： =LOOKUP(LEFT(A2),PY)&LOOKUP(

『叄』 在excel中如何提取漢字的第一個拼音字母

如A列是漢字，從A1開始，則B1中的公式為：

=LOOKUP(CODE(A1),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})

下拉填充

『肆』 excel怎麼把漢字轉換成拼音

Excel中可以利用自定義函數來實現將漢字轉換成拼音。

所用工具：Office2007

舉例說明如下：

1.將A列數據轉換成拼音：

『伍』 excel表漢字生成拼音的方法

利用word的拼音指南功能，假設A列為漢字

1. 你要先選中A列，復制黏貼到word中，選擇僅保留文本

2. ctrl+A,菜單欄拼音指南，確定

3. ctrl+A,復制，黏貼回excel的A列

4. =phonetic(A1),下拖

5. 把excel的拼音指南關掉

『陸』 在EXCEL中怎樣批量將漢字轉為拼音

無法保證多音字能正確轉換，如姓單（Shan）的，可能轉換為Dan了

『柒』 如何將EXCEL表格中的漢字轉為拼音

1、打開要轉換成拼音的excel表格

2、按「Alt+F11」組合鍵，進入Visual Basic編輯狀態。也就是看到的這個灰色的編輯界面

3、執行「插入→模塊」命令，插入一個新模塊。再雙擊插入的模塊，進入模塊代碼編輯狀態；

4、看到如下界面

5、把下面的所有內容復制，粘貼到步驟4中的空白處

復制內容到剪貼板

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 = " "

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 -10587 To -10545: pinyin = " "

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 getpy(str)

For i = 1 To Len(str)

getpy = getpy & pinyin(Mid(str, i, 1))

Next i

End Function

6、按下ALT+Q關閉Visual Basic編輯窗口，返回Excel編輯狀態

7、選中轉換後的拼音需要放在哪個列，例如要把B列的第2行的內容轉換成拼音，放在D列的第2個單元格，輸入公式：=getpy(B2)，這里的B2，是指源頭單元格的坐標

8、如果要去除拼音之間的空格。去掉空格的拼音放在E列，如果這個未去掉空格的數據原來在D2單元格，去掉空格之後的拼音放在E2單元格，則在E2單元格輸入：
=SUBSTITUTE(D2," ","")

『捌』 怎樣在EXCEL中自動生成拼音

1、首先在電腦桌面上打開excel文檔。

注意事項：

1、在使用excel表格的時候，不要隨意的按enter和空白鍵。

2、要善於利用excel表格裡面的快捷鍵，進行excel表格的編輯。

3、在使用excel表格的時候，一定要定時的進行保存。

4、在使用excel表格的時候，一旦有不懂的問題，一定要及時的向專業人員進行咨詢。