摘要
Excel是使用非常广泛的办公软件体系之一,自身带有多种类型、可实现多种功能的内置函数,但仍不能完全满足一些用户的特殊功能使用要求。基于此,Excel提供了宏功能,满足用户通过自定义的方式开发独特功能的使用需求。利用VBA的宏编程技术,通过自定义Excel函数,实现Excel单元格数据中指定字符间文本的批量去除功能,同时提供指定字符去除或保留两种实现模式的解决方案。
Excel is one of the more widely used office software systems.It has many types of built-in functions to realize many functions,but it still cannot fully meet the usage requirements of special functions of some users.In view of this,Excel provides macro functions to satisfy user’s usage requirements that develop unique functions through self-definition way.Using the macro programming technology of VBA and through self-definition of Excel function,the batch removal function of the text between the specified characters in the Excel cell data is realized.At the same time,two implementation modes of solutions removing or retaining of the specified characters are provided.
作者
高楠
徐刚
GAO Nan;XU Gang(Lanzhou City University,Lanzhou 730070,China)
出处
《现代信息科技》
2021年第2期32-34,共3页
Modern Information Technology
基金
兰州城市学院本科教学研究与改革项目(2020-JY-11)。
