1.EXCEL中能否直接把中文转换成拼音？
2.如何在excel中把汉字转换成拼音
3.已知关键词为26，公式公式17，源码源码19，使用12，公式公式23，源码源码34，使用怎样搭建共享平台源码24，公式公式25，源码源码30，使用34，公式公式
4.以一个实例说明在excel中根据A列汉字自动在B列生成拼音字母的源码源码方法
EXCEL中能否直接把中文转换成拼音？
Excel内是可以把中文转换成为拼音的，但需要转换函数（函数可通过网络上面下载），使用下面给出具体操作方法：所需材料：Excel、公式公式准备好的源码源码中文转拼音函数。
一、使用首先打开Excel软件，然后按Alt+F打开Viaual Basic编辑器，点击工具栏“插入”，选项内点击“模块”。
二、这时把准备好的缓存雪崩原文源码中文转拼音函数粘贴入该模块下，然后就可以关闭掉Viaual Basic编辑器。
三、回到Excel界面在需要转换的单元格内输入中文转拼音的公式（这里需要根据下载的函数来输入对应的公式，如下图的公式为=pinyin，而有一些公式则为=getpy，注意公式不要用错），按下回车键即可得到公式内所求单元格的拼音。
四、最后按住已转换完成单元格右下角向下拖动即可得到整列中文的拼音 。
如何在excel中把汉字转换成拼音
利用EXCEl表格中的单页源码网站宏，轻松将汉字转换为拼音
1.启动Excel （其它版本请仿照操作），打开相应的工作表；
2.执行“工具→宏→Visual Basic编辑器”命令（或者直接按“Alt+F”组合键），进入Visual Basic编辑状态；
3.执行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态；
4.将代码输入其中； Function pinyin(p As String) As String i = Asc(p) Select Case i Case - To -: pinyin = "a " Case - To -: pinyin = "ai " Case - To -: pinyin = "an " Case - To -: pinyin = "ang " Case - To -: pinyin = "ao " Case - To -: pinyin = "ba " Case - To -: pinyin = "bai " Case - To -: pinyin = "ban " Case - To -: pinyin = "bang " Case - To -: pinyin = "bao " Case - To -: pinyin = "bei " Case - To -: pinyin = "ben " Case - To -: pinyin = "beng " Case - To -: pinyin = "bi " Case - To -: pinyin = "bian " Case - To -: pinyin = "biao " Case - To -: pinyin = "bie " Case - To -: pinyin = "bin " Case - To -: pinyin = "bing " Case - To -: pinyin = "bo " Case - To -: pinyin = "bu " Case - To -: pinyin = "ca " Case - To -: pinyin = "cai " Case - To -: pinyin = "can " Case - To -: pinyin = "cang " Case - To -: pinyin = "cao " Case - To -: pinyin = "ce " Case - To -: pinyin = "ceng " Case - To -: pinyin = "cha " Case - To -: pinyin = "chai " Case - To -: pinyin = "chan " Case - To -: pinyin = "chang " Case - To -: pinyin = "chao " Case - To -: pinyin = "che " Case - To -: pinyin = "chen " Case - To -: pinyin = "cheng " Case - To -: pinyin = "chi " Case - To -: pinyin = "chong " Case - To -: pinyin = "chou " Case - To -: pinyin = "chu " Case - To -: pinyin = "chuai " Case - To -: pinyin = "chuan " Case - To -: pinyin = "chuang " Case - To -: pinyin = "chui " Case - To -: pinyin = "chun " Case - To -: pinyin = "chuo " Case - To -: pinyin = "ci " Case - To -: pinyin = "cong " Case - To -: pinyin = "cou " Case - To -: pinyin = "cu " Case - To -: pinyin = "cuan " Case - To -: pinyin = "cui " Case - To -: pinyin = "cun " Case - To -: pinyin = "cuo " Case - To -: pinyin = "da " Case - To -: pinyin = "dai " Case - To -: pinyin = "dan " Case - To -: pinyin = "dang " Case - To -: pinyin = "dao " Case - To -: pinyin = "de " Case - To -: pinyin = "deng " Case - To -: pinyin = "di " Case - To -: pinyin = "dian " Case - To -: pinyin = "diao " Case - To -: pinyin = "die " Case - To -: pinyin = "ding " Case - To -: pinyin = "diu " Case - To -: pinyin = "dong " Case - To -: pinyin = "fa " Case - To -: pinyin = "fan " Case - To -: pinyin = "fang " Case - To -: pinyin = "fei " Case - To -: pinyin = "fen " Case - To -: pinyin = "feng " Case - To -: pinyin = "fo " Case - To -: pinyin = "fou " Case - To -: pinyin = "fu " Case - To -: pinyin = "ga " Case - To -: pinyin = "gai " Case - To -: pinyin = "gan " Case - To -: pinyin = "gang " Case - To -: pinyin = "gao " Case - To -: pinyin = "ge " Case - To -: pinyin = "gei " Case - To -: pinyin = "gen " Case - To -: pinyin = "geng " Case - To -: pinyin = "gong " Case - To -: pinyin = "gou " Case - To -: pinyin = "gu " Case - To -: pinyin = "gua " Case - To -: pinyin = "guai " Case - To -: pinyin = "guan " Case - To -: pinyin = "guang " Case - To -: pinyin = "gui " Case - To -: pinyin = "gun " Case - To -: pinyin = "guo " Case - To -: pinyin = "ha " Case - To -: pinyin = "hai " Case - To -: pinyin = "han " Case - To -: pinyin = "hang " Case - To -: pinyin = "hao " Case - To -: pinyin = "he " Case - To -: pinyin = "hei " Case - To -: pinyin = "hen " Case - To -: pinyin = "heng " Case - To -: pinyin = "hong " Case - To -: pinyin = "hou " Case - To -: pinyin = "hu " Case - To -: pinyin = "hua " Case - To -: pinyin = "huai " Case - To -: pinyin = "huan " Case - To -: pinyin = "huang " Case - To -: pinyin = "hui " Case - To -: pinyin = "hun " Case - To -: pinyin = "huo " Case - To -: pinyin = "ji " Case - To -: pinyin = "jia " Case - To -: pinyin = "jian " Case - To -: pinyin = "jiang " Case - To -: pinyin = "jiao " Case - To -: pinyin = "jie " Case - To -: pinyin = "jin " Case - To -: pinyin = "jing " Case - To -: pinyin = "jiong " Case - To -: pinyin = "jiu " Case - To -: pinyin = "ju " Case - To -: pinyin = "juan " Case - To -: pinyin = "jue " Case - To -: pinyin = "jun " Case - To -: pinyin = "ka " Case - To -: pinyin = "kai " Case - To -: pinyin = "kan " Case - To -: pinyin = "kang " Case - To -: pinyin = "kao " Case - To -: pinyin = "ke " Case - To -: pinyin = "ken " Case - To -: pinyin = "keng " Case - To -: pinyin = "kong " Case - To -: pinyin = "kou " Case - To -: pinyin = "ku " Case - To -: pinyin = "kua " Case - To -: pinyin = "kuai " Case - To -: pinyin = "kuan " Case - To -: pinyin = "kuang " Case - To -: pinyin = "kui " Case - To -: pinyin = "kun " Case - To -: pinyin = "kuo " Case - To -: pinyin = "la " Case - To -: pinyin = "lai " Case - To -: pinyin = "lan " Case - To -: pinyin = "lang " Case - To -: pinyin = "lao " Case - To -: pinyin = "le " Case - To -: pinyin = "lei " Case - To -: pinyin = "leng " Case - To -: pinyin = "li " Case - To -: pinyin = "lia " Case - To -: pinyin = "lian " Case - To -: pinyin = "liang " Case - To -: pinyin = "liao " Case - To -: pinyin = "lie " Case - To -: pinyin = "lin " Case - To -: pinyin = "ling " Case - To -: pinyin = "liu " Case - To -: pinyin = "long " Case - To -: pinyin = "lou " Case - To -: pinyin = "lu " Case - To -: pinyin = "lv " Case - To -: pinyin = "luan " Case - To -: pinyin = "lue " Case - To -: pinyin = "lun " Case - To -: pinyin = "luo " Case - To -: pinyin = "ma " Case - To -: pinyin = "mai " Case - To -: pinyin = "man " Case - To -: pinyin = "mang " Case - To -: pinyin = "mao " Case - To -: pinyin = "me " Case - To -: pinyin = "mei " Case - To -: pinyin = "men " Case - To -: pinyin = "meng " Case - To -: pinyin = "mi " Case - To -: pinyin = "mian " Case - To -: pinyin = "miao " Case - To -: pinyin = "mie " Case - To -: pinyin = "min " Case - To -: pinyin = "ming " Case - To -: pinyin = "miu " Case - To -: pinyin = "mo " Case - To -: pinyin = "mou " Case - To -: pinyin = "mu " Case - To -: pinyin = "na " Case - To -: pinyin = "nai " Case - To -: pinyin = "nan " Case - To -: pinyin = "nang " Case - To -: pinyin = "nao " Case - To -: pinyin = "ne " Case - To -: pinyin = "nei " Case - To -: pinyin = "nen " Case - To -: pinyin = "neng " Case - To -: pinyin = "ni " Case - To -: pinyin = "nian " Case - To -: pinyin = "niang " Case - To -: pinyin = "niao " Case - To -: pinyin = "nie " Case - To -: pinyin = "nin " Case - To -: pinyin = "ning " Case - To -: pinyin = "niu " Case - To -: pinyin = "nong " Case - To -: pinyin = "nu " Case - To -: pinyin = "nv " Case - To -: pinyin = "nuan " Case - To -: pinyin = "nue " Case - To -: pinyin = "nuo " Case - To -: pinyin = "o " Case - To -: pinyin = "ou " Case - To -: pinyin = "pa " Case - To -: pinyin = "pai " Case - To -: pinyin = "pan " Case - To -: pinyin = "pang " Case - To -: pinyin = "pao " Case - To -: pinyin = "pei " Case - To -: pinyin = "pen " Case - To -: pinyin = "peng " Case - To -: pinyin = "pi " Case - To -: pinyin = "pian " Case - To -: pinyin = "piao " Case - To -: pinyin = "pie " Case - To -: pinyin = "pin " Case - To -: pinyin = "ping " Case - To -: pinyin = "po " Case - To -: pinyin = "pu " Case - To -: pinyin = "qi " Case - To -: pinyin = "qia " Case - To -: pinyin = "qian " Case - To -: pinyin = "qiang " Case - To -: pinyin = "qiao " Case - To -: pinyin = "qie " Case - To -: pinyin = "qin " Case - To -: pinyin = "qing " Case - To -: pinyin = "qiong " Case - To -: pinyin = "qiu " Case - To -: pinyin = "qu " Case - To -: pinyin = "quan " Case - To -: pinyin = "que " Case - To -: pinyin = "qun " Case - To -: pinyin = "ran " Case - To -: pinyin = "rang " Case - To -: pinyin = "rao " Case - To -: pinyin = "re " Case - To -: pinyin = "ren " Case - To -: pinyin = "reng " Case - To -: pinyin = "ri " Case - To -: pinyin = "rong " Case - To -: pinyin = "rou " Case - To -: pinyin = "ru " Case - To -: pinyin = "ruan " Case - To -: pinyin = "rui " Case - To -: pinyin = "run " Case - To -: pinyin = "ruo " Case - To -: pinyin = "sa " Case - To -: pinyin = "sai " Case - To -: pinyin = "san " Case - To -: pinyin = "sang " Case - To -: pinyin = "sao " Case - To -: pinyin = "se " Case - To -: pinyin = "sen " Case - To -: pinyin = "seng " Case - To -: pinyin = "sha " Case - To -: pinyin = "shai " Case - To -: pinyin = "shan " Case - To -: pinyin = "shang " Case - To -: pinyin = "shao " Case - To -: pinyin = "she " Case - To -: pinyin = "shen " Case - To -: pinyin = "sheng " Case - To -: pinyin = "shi " Case - To -: pinyin = "shou " Case - To -: pinyin = "shu " Case - To -: pinyin = "shua " Case - To -: pinyin = "shuai " Case - To -: pinyin = "shuan " Case - To -: pinyin = "shuang " Case - To -: pinyin = "shui " Case - To -: pinyin = "shun " Case - To -: pinyin = "shuo " Case - To -: pinyin = "si " Case - To -: pinyin = "song " Case - To -: pinyin = "sou " Case - To -: pinyin = "su " Case - To -: pinyin = "suan " Case - To -: pinyin = "sui " Case - To -: pinyin = "sun " Case - To -: pinyin = "suo " Case - To -: pinyin = "ta " Case - To -: pinyin = "tai " Case - To -: pinyin = "tan " Case - To -: pinyin = "tang " Case - To -: pinyin = "tao " Case - To -: pinyin = "te " Case - To -: pinyin = "teng " Case - To -: pinyin = "ti " Case - To -: pinyin = "tian " Case - To -: pinyin = "tiao " Case - To -: pinyin = "tie " Case - To -: pinyin = "ting " Case - To -: pinyin = "tong " Case - To -: pinyin = "tou " Case - To -: pinyin = "tu " Case - To -: pinyin = "tuan " Case - To -: pinyin = "tui " Case - To -: pinyin = "tun " Case - To -: pinyin = "tuo " Case - To -: pinyin = "wa " Case - To -: pinyin = "wai " Case - To -: pinyin = "wan " Case - To -: pinyin = "wang " Case - To -: pinyin = "wei " Case - To -: pinyin = "wen " Case - To -: pinyin = "weng " Case - To -: pinyin = "wo " Case - To -: pinyin = "wu " Case - To -: pinyin = "xi " Case - To -: pinyin = "xia " Case - To -: pinyin = "xian " Case - To -: pinyin = "xiang " Case - To -: pinyin = "xiao " Case - To -: pinyin = "xie " Case - To -: pinyin = "xin " Case - To -: pinyin = "xing " Case - To -: pinyin = "xiong " Case - To -: pinyin = "xiu " Case - To -: pinyin = "xu " Case - To -: pinyin = "xuan " Case - To -: pinyin = "xue " Case - To -: pinyin = "xun " Case - To -: pinyin = "ya " Case - To -: pinyin = "yan " Case - To -: pinyin = "yang " Case - To -: pinyin = "yao " Case - To -: pinyin = "ye " Case - To -: pinyin = "yi " Case - To -: pinyin = "yin " Case - To -: pinyin = "ying " Case - To -: pinyin = "yo " Case - To -: pinyin = "yong " Case - To -: pinyin = "you " Case - To -: pinyin = "yu " Case - To -: pinyin = "yuan " Case - To -: pinyin = "yue " Case - To -: pinyin = "yun " Case - To -: pinyin = "za " Case - To -: pinyin = "zai " Case - To -: pinyin = "zan " Case - To -: pinyin = "zang " Case - To -: pinyin = "zao " Case - To -: pinyin = "ze " Case - To -: pinyin = "zei " Case - To -: pinyin = "zen " Case - To -: pinyin = "zeng " Case - To -: pinyin = "zha " Case - To -: pinyin = "zhai " Case - To -: pinyin = "zhan " Case - To -: pinyin = "zhang " Case - To -: pinyin = "zhao " Case - To -: pinyin = "zhe " Case - To -: pinyin = "zhen " Case - To -: pinyin = "zheng " Case - To -: pinyin = "zhi " Case - To -: pinyin = "zhong " Case - To -: pinyin = "zhou " Case - To -: pinyin = "zhu " Case - To -: pinyin = "zhua " Case - To -: pinyin = "zhuai " Case - To -: pinyin = "zhuan " Case - To -: pinyin = "zhuang " Case - To -: pinyin = "zhui " Case - To -: pinyin = "zhun " Case - To -: pinyin = "zhuo " Case - To -: pinyin = "zi " Case - To -: pinyin = "zong " Case - To -: pinyin = "zou " Case - To -: pinyin = "zu " Case - To -: pinyin = "zuan " Case - To -: pinyin = "zui " Case - To -: pinyin = "zun " Case - To -: 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
5.代码输入完成后，直接关闭Visual Basic编辑窗口，返回Excel编辑状态；
6.自定义函数就可以用了，如：选中A2单元格，输入公式：=getpy(A2)。lol副图源码
已知关键词为，，，，，，，，，，成品app源码视频
解：（1）先确定哈希表的长度：根据公式：α= n/m, （n为记录数，m为表长）可知因为α不小于0.，所以当记录数为时，可以设表长为，此时α的值为0.
（2）根据关键字首字母的排序建立哈希表，若首字母相同则将第二个字母的排序加上，依次类推，易知
可以转换为数字ZHAO = ；QIAN = ；SUN = ；LI = ；ZHOU = ；WU = ；
ZHANG = ；WANG = ；CHANG = 3；CHAO = ；YANG = ；JIN =
（3）
增量di设为di = i((k)MOD+1
H(key) = (3k)MOD
易求得哈希表为：
H() = ;
H() = ;
H() = ;
H() =
H() = 2;
H() = 9;
H() = 5;
H() = ;
H(3) = 9;H1(3) = 7;
H() = ;
H() = ;
H() = ;
平均查找长度：
ASLsucc = (1×+2)/=/;
以一个实例说明在excel中根据A列汉字自动在B列生成拼音字母的方法
下图所示的excel表格，A列是姓名列，根据A列的汉字姓名，自动在B列和C列分别自动生成姓名列的拼音字母。
下面是小编整理出来的详细的操作步骤，分享给有需要的朋友。
第一步，由于Excel中没有现成的函数套用可以解决此问题，首先自定义一个函数。方法如下：
1. 运行“工具→宏→Visual Basic编辑器”命令（或者直接按“Alt+F”组合键），进入Visual Basic编辑状态。
2. 运行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态。
3. 将以下的代码输入其中，保存，关闭Visual Basic编辑窗口，返回Excel编辑状态。
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,,ai,,an,,ang,,ao,,"
PinMa = PinMa & "ba,,bai,,ban,,bang,,bao,,bei,,ben,,beng,,bi,,bian,,biao,,bie,,bin,,bing,,bo,,bu,,"
PinMa = PinMa & "ca,,cai,,can,,cang,,cao,,ce,,ceng,,cha,,chai,,chan,,chang,,chao,,che,,chen,,cheng,,chi,,chong,,chou,,chu,,chuai,,chuan,,chuang,,chui,,chun,,chuo,,ci,,cong,,cou,,cu,,cuan,,cui,,cun,,cuo,,"
PinMa = PinMa & "da,,dai,,dan,,dang,,dao,,de,,deng,,di,,dian,,diao,,die,,ding,,diu,,dong,,dou,,du,,duan,,dui,,dun,,duo,,"
PinMa = PinMa & "e,,en,,er,,"
PinMa = PinMa & "fa,,fan,,fang,,fei,,fen,,feng,,fo,,fou,,fu,,"
PinMa = PinMa & "ga,,gai,,gan,,gang,,gao,,ge,,gei,,gen,,geng,,gong,,gou,,gu,,gua,,guai,,guan,,guang,,gui,,gun,,guo,,"
PinMa = PinMa & "ha,,hai,,han,,hang,,hao,,he,,hei,,hen,,heng,,hong,,hou,,hu,,hua,,huai,,huan,,huang,,hui,,hun,,huo,,"
PinMa = PinMa & "ji,,jia,,jian,,jiang,,jiao,,jie,,jin,,jing,,jiong,,jiu,,ju,,juan,,jue,,jun,,"
PinMa = PinMa & "ka,,kai,,kan,,kang,,kao,,ke,,ken,,keng,,kong,,kou,,ku,,kua,,kuai,,kuan,,kuang,,kui,,kun,,kuo,,"
PinMa = PinMa & "la,,lai,,lan,,lang,,lao,,le,,lei,,leng,,li,,lia,,lian,,liang,,liao,,lie,,lin,,ling,,liu,,long,,lou,,lu,,lv,,luan,,lue,,lun,,luo,,"
PinMa = PinMa & "ma,,mai,,man,,mang,,mao,,me,,mei,,men,,meng,,mi,,mian,,miao,,mie,,min,,ming,,miu,,mo,,mou,,mu,,"
PinMa = PinMa & "na,,nai,,nan,,nang,,nao,,ne,,nei,,nen,,neng,,ni,,nian,,niang,,niao,,nie,,nin,,ning,,niu,,nong,,nu,,nv,,nuan,,nue,,nuo,,"
PinMa = PinMa & "o,,ou,,"
PinMa = PinMa & "pa,,pai,,pan,,pang,,pao,,pei,,pen,,peng,,pi,,pian,,piao,,pie,,pin,,ping,,po,,pu,,"
PinMa = PinMa & "qi,,qia,,qian,,qiang,,qiao,,qie,,qin,,qing,,qiong,,qiu,,qu,,quan,,que,,qun,,"
PinMa = PinMa & "ran,,rang,,rao,,re,,ren,,reng,,ri,,rong,,rou,,ru,,ruan,,rui,,run,,ruo,,"
PinMa = PinMa & "sa,,sai,,san,,sang,,sao,,se,,sen,,seng,,sha,,shai,,shan,,shang,,shao,,she,,shen,,sheng,,shi,,shou,,shu,,shua,,shuai,,shuan,,shuang,,shui,,shun,,shuo,,si,,song,,sou,,su,,suan,,sui,,sun,,suo,,"
PinMa = PinMa & "ta,,tai,,tan,,tang,,tao,,te,,teng,,ti,,tian,,tiao,,tie,,ting,,tong,,tou,,tu,,tuan,,tui,,tun,,tuo,,"
PinMa = PinMa & "wa,,wai,,wan,,wang,,wei,,wen,,weng,,wo,,wu,,"
PinMa = PinMa & "xi,,xia,,xian,,xiang,,xiao,,xie,,xin,,xing,,xiong,,xiu,,xu,,xuan,,xue,,xun,,"
PinMa = PinMa & "ya,,yan,,yang,,yao,,ye,,yi,,yin,,ying,,yo,,yong,,you,,yu,,yuan,,yue,,yun,,"
PinMa = PinMa & "za,,zai,,zan,,zang,,zao,,ze,,zei,,zen,,zeng,,zha,,zhai,,zhan,,zhang,,zhao,,zhe,,zhen,,zheng,,zhi,,zhong,,zhou,,zhu,,zhua,,zhuai,,zhuan,,zhuang,,zhui,,zhun,,zhuo,,zi,,zong,,zou,,zu,,zuan,,zui,,zun,,zuo,"
MyPinMa = Split(PinMa, ",")
For i = 1 To Len(Hz)
Temp = Asc(Mid(Hz, i, 1))
If Temp < 0 Then
Temp = Abs(Temp)
For j = 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
第二步，在空白列，比如F2单元格，输入公式：=PinYin(A2)，就可以在F2单元格得到A2单元格汉字的拼音。然后下拉复制完成A列所有的汉字转拼音。
提示：公式中的“PinYin”就是第一步自定义函数的名称。
第三步，在B2单元格输入公式：=LEFT(F2,FIND(" ",F2)-1)，就可以提取出F2单元格中的第一个汉字的拼音。然后下拉复制完成A列中汉字“姓”的拼音提取。
第四步，在C2单元格输入公式：=TRIM(SUBSTITUTE(F2,B2,""))，即可得到剩余的“名”字部分的汉字的拼音。下拉复制公式。
第五步，如果需要拼音的首字母大写，可以再用PROPER函数来转换一下。最终完成的效果如下图所示。
