WPS中EXCEL 获取中文首字母缩写 | 您所在的位置:网站首页 › excel提取汉字笔画函数 › WPS中EXCEL 获取中文首字母缩写 |
1. 下载WPS2019VB插件
如果不下载的话,VB编辑器一栏会显示灰色不可用 链接:https://pan.baidu.com/s/1PV_p3ngP9zUaszQs70-kSA 提取码:pghg 2. 打开VB编辑器【开发工具】->【VB编辑器】 打开【开发工具】菜单,点击【VB编辑器】,弹出代码窗口, 在窗口左侧空白处,点击右键,选择【插入】->【模块】。窗口右侧出现一个白色背景框。 复制粘贴如下内容到右侧框中: Function getpychar(char) tmp = 65536 + Asc(char) If (tmp >= 45217 And tmp = 45253 And tmp = 45761 And tmp = 46318 And tmp = 46826 And tmp = 47010 And tmp = 47297 And tmp = 47614 And tmp = 48119 And tmp = 49062 And tmp = 49324 And tmp = 49896 And tmp = 50371 And tmp = 50614 And tmp = 50622 And tmp = 50906 And tmp = 51387 And tmp = 51446 And tmp = 52218 And tmp = 52698 And tmp = 52980 And tmp = 53679 And tmp = 54481 And tmp |
CopyRight 2018-2019 实验室设备网 版权所有 |