夜雨聆风 > > 办公文件 > Excel拆分、组合、凑数、大写,这些操作很简单
当前时间： 2026-08-07 21:25:02
分类：办公文件
评论(0)
Excel拆分、组合、凑数、大写,这些操作很简单小伙伴们好啊，今天再和大家分享Office增强插件易用宝中的几个操作技巧。依次单击【易用宝】→【区域转换】→【排列组合】，在对话框中切换到【拆分组合】，选择区域和间隔符号即可。如下图所示，要将A列的品类和B列的等级分别进行组合，得到一个品类和等级的表格。依次单击【易用宝】→【区域转换】→【排列组合】，在对话框中选择区域即可。如下图所示，D列是一些员工提成数据，已知发票金额是30259，希望知道是由哪些提成金额构成。选择数据源区域，依次单击【易用宝plus】→【凑数】，在对话框中输入目标值，单击【确定】。选择数据区域，依次单击【易用宝】→【数值转换】→【数字转中文大写金额】。
点击[阅读原文]，了解易用宝更多亮眼功能。
<本文含广告>
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-08-11 13:16:15 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/881132.html
- 运行时间 : 0.227994s [ 吞吐率：4.39req/s ] 内存消耗：4,661.55kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=246e9dee3e520d0652a35244d0d0ad3c
- CONNECT:[ UseTime:0.001062s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001531s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000723s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000673s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001316s ]
- SELECT * FROM `set` [ RunTime:0.000582s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001429s ]
- SELECT * FROM `article` WHERE `id` = 881132 LIMIT 1 [ RunTime:0.001018s ]
- UPDATE `article` SET `lasttime` = 1786425375 WHERE `id` = 881132 [ RunTime:0.015421s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000601s ]
- SELECT * FROM `article` WHERE `id` < 881132 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001016s ]
- SELECT * FROM `article` WHERE `id` > 881132 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001659s ]
- SELECT * FROM `article` WHERE `id` < 881132 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.003877s ]
- SELECT * FROM `article` WHERE `id` < 881132 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001987s ]
- SELECT * FROM `article` WHERE `id` < 881132 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.004304s ]
0.231897s
夜雨聆风
