转换方法如下:
所需材料:Excel、中文转拼音函数(需通过网络下载)。
一、打开Excel,然后按Alt键+F11键打开Viaual Basic编辑器,点击工具栏插入,下拉菜单内点击模块。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0824ab18972bd407d55214fe74899e510fb30918?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、打开模块1后,在下方空白处粘贴入准备好的中文转拼音函数,然后关闭Viaual Basic编辑器。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/50da81cb39dbb6fd88a622250624ab18972b3730?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、回到Excel界面,在任意一空白单元格内输入“=getpy(单元格)”,按回车键即可得到该单元格的拼音。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aec379310a55b31912b844764ca98226cffc1774?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、最后鼠标按着已经转换完成的拼音单元格右下角,向下拖动。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513d099eaadd326d55fbb2fbd9f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
五、这样就可以把整列汉字转换为拼音。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7fd5266d016092477666418db0735fae6cd3476?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)