1、首先我们先打开需要删除空格的excel表,打开之后会出现,这时候我们将鼠标单击一个对话框,然后移到输入框里面我们可以看到该单元格的后方有一个空格。
/iknow-pic.cdn.bcebos.com/d01373f082025aafcbc0389bf5edab64024f1aeb"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d01373f082025aafcbc0389bf5edab64024f1aeb?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/d01373f082025aafcbc0389bf5edab64024f1aeb"/>
2、假如A列都是有空格的,那么我们将A列全部选上,选上之后单击“数据”按钮。
/iknow-pic.cdn.bcebos.com/267f9e2f0708283887dc9a44b699a9014d08f189"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/267f9e2f0708283887dc9a44b699a9014d08f189?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/267f9e2f0708283887dc9a44b699a9014d08f189"/>
3、单击数据按钮之后会出现,此时我们单击“分列“按钮。
/iknow-pic.cdn.bcebos.com/203fb80e7bec54e7c8e85b4eb7389b504fc26a5e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/203fb80e7bec54e7c8e85b4eb7389b504fc26a5e?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/203fb80e7bec54e7c8e85b4eb7389b504fc26a5e"/>
4、单击之后会弹出对话框,此时我们单击”下一步“按钮。
/iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7a1188cbcdf00baa1cd112a41"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7a1188cbcdf00baa1cd112a41?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/6609c93d70cf3bc7a1188cbcdf00baa1cd112a41"/>
5、单击之后还是会弹出对话框,此时我们可以看到有一个”空格“选项,我们在该选项的前面打勾,然后单击”下一步“按钮。
/iknow-pic.cdn.bcebos.com/b21c8701a18b87d6b433ea4f090828381f30fd69"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b21c8701a18b87d6b433ea4f090828381f30fd69?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/b21c8701a18b87d6b433ea4f090828381f30fd69"/>
6、单击之后会出现,此时我们下方的”完成“按钮。
/iknow-pic.cdn.bcebos.com/b03533fa828ba61e87ac897f4f34970a304e591b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b03533fa828ba61e87ac897f4f34970a304e591b?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/b03533fa828ba61e87ac897f4f34970a304e591b"/>
7、单击完成按钮之后会回到,此时我们可以看到单元格可以计算公式了,而且单元格数值后方的空格已经被批量删除了。
/iknow-pic.cdn.bcebos.com/730e0cf3d7ca7bcbca22867fb0096b63f624a801"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/730e0cf3d7ca7bcbca22867fb0096b63f624a801?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/730e0cf3d7ca7bcbca22867fb0096b63f624a801"/>