如题所述
一、首先,打开Excel表格程序,进入主界面中,选中一个蒂娜元个发信啊前面带有小逗号。
/iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee67ebd54123f5e0fe98257e99"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee67ebd54123f5e0fe98257e99?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee67ebd54123f5e0fe98257e99"/>
二、然后,在空白的单元格位置,输入“1”,点击打开。
/iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb7aac824a414a20a44723dce7"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb7aac824a414a20a44723dce7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb7aac824a414a20a44723dce7"/>
三、然后,在Excel程序主界面上方选择“格式刷”,点击打开。
/iknow-pic.cdn.bcebos.com/d8f9d72a6059252d8091c75c3a9b033b5ab5b9e0"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d8f9d72a6059252d8091c75c3a9b033b5ab5b9e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/d8f9d72a6059252d8091c75c3a9b033b5ab5b9e0"/>
四、然后,继续用“格式刷”刷需要批量去除逗号的单元格。
/iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd575d232ac5fda81cb38db3de1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd575d232ac5fda81cb38db3de1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd575d232ac5fda81cb38db3de1"/>
五、最后,可以看到Excel单元格内的逗号批量去除成功,问题解决。
/iknow-pic.cdn.bcebos.com/00e93901213fb80efa52bb8f38d12f2eb83894e3"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/00e93901213fb80efa52bb8f38d12f2eb83894e3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/00e93901213fb80efa52bb8f38d12f2eb83894e3"/>
/iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee67ebd54123f5e0fe98257e99"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee67ebd54123f5e0fe98257e99?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee67ebd54123f5e0fe98257e99"/>
二、然后,在空白的单元格位置,输入“1”,点击打开。
/iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb7aac824a414a20a44723dce7"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb7aac824a414a20a44723dce7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb7aac824a414a20a44723dce7"/>
三、然后,在Excel程序主界面上方选择“格式刷”,点击打开。
/iknow-pic.cdn.bcebos.com/d8f9d72a6059252d8091c75c3a9b033b5ab5b9e0"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d8f9d72a6059252d8091c75c3a9b033b5ab5b9e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/d8f9d72a6059252d8091c75c3a9b033b5ab5b9e0"/>
四、然后,继续用“格式刷”刷需要批量去除逗号的单元格。
/iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd575d232ac5fda81cb38db3de1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd575d232ac5fda81cb38db3de1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd575d232ac5fda81cb38db3de1"/>
五、最后,可以看到Excel单元格内的逗号批量去除成功,问题解决。
/iknow-pic.cdn.bcebos.com/00e93901213fb80efa52bb8f38d12f2eb83894e3"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/00e93901213fb80efa52bb8f38d12f2eb83894e3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/00e93901213fb80efa52bb8f38d12f2eb83894e3"/>
温馨提示:答案为网友推荐,仅供参考