1、A列中的数据没有单引号就很难添加到数据库中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3d7d23ff80b4a1cd11738b29bb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后我们就开始定位一个空白单元格开始给数据添加单引号。这个空白单元格定位的位置跟要添加引号的数据相应即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3dee08ea3d49aeef01f3a297945?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后在编辑栏输入公式便可以开始给数据添加单引号或其他对应符号了哦。双引号所引住的便是要添加的符号,然后用&符号来拼接单元格以及符号即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4afbfbedab64034fc0dad8b6a1c379310a551d6e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、接着我们用Ctrl键点击选中A1和D1两个单元格并且按Ctrl和C键复制它们。当复制完这两个单元格之后还需要点击一下D1单元格哦。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbf00aeaf8a17d8bc3eb135416b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后鼠标按放在D1单元格右下处下拉便能够对A列的数据进行复制并添加单引号了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cfb9b6b0bdf6dcd100baa12b35?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳