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表格的时候，一旦有不懂的问题，一定要及时的向专业人员进行咨询。