1.演示使用的软件为Excel电子表格,软件版本为officehome和studentedition2016。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800ade216872a13533fa838b4782?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2.打开Excel表格,在表格中输入“3+6+7”等数据列,演示批量添加字符副本的操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c8146f3cd94ac3eb13532fa4082?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3.在单元格b1中输入“=”=“&A1”。这个公式表示使用连接符号“&”将符号“=”与单元格A1的内容连接起来。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9358d109b3de9c8212a118f37c81800a18d84382?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4.完成输入后,单击enter,可以看到在字符串zd“3+6+7”前面添加了符号“=”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbfa978544609d8bc3eb0354182?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5.如果有很多这样的单元格,我们可以使用格式填充句柄进行批处理填充操作,我们可以看到显示的结果是正确的。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d009b3de9c82d1580846b8cd900a19d8bd3e4282?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)