Excel:字符串之连接操作

在日常办公中,经常遇到Excel表格数据整合之类的操作。但是当数据量很大时,手工操作不仅费劲,而且经常出错。本文以Excel中字符串连接的操作为例,研究利用VBA①语言,编写相应程序,解决繁锁的重复性劳动,大大提高了工作效率。

Excel:Concatenated Operation of the Character String

In the daily office work,we usually meet Microsoft Excel operations,such as data integration operation.But when the data quantity is very big,the manual operation is not only taking a lot of time,but also making mistakes.This paper takes concatenated operation of strings in Excel as an example to write corresponding programs in the use of VBA, to solve the cumbersome and repetitive work and improve the working efficiency greatly.