第1个回答 2019-05-21
工具/原材料
excel2016版、电脑。
1、打开电脑找到并点击打开excel2016版表格软件;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a600c338744ebf800e2729ad7f9d72a6159a787?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、双击打开excel表格软件以后,为了示范先在表格内编辑好任意的文字内容;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b219ebc4b74543a94e08eb6910178a82b9011407?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、编辑好以后,此时先将A1列需要拆分的部份内容复制粘贴到B和C列,只需要复制第一行;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bf096b63f6246b60192aa2d1e5f81a4c510fa26a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、复制粘贴好第一行的内容以后,此时单击B1列在按“ctrl+E”快捷键进行单元格填充即可;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a605938c1f1bf2634349b023bba45?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、同理此时单击C1列在按“ctrl+E”快捷键进行数字部份单元格填充拆分即可完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6159252dd42a28342b4125ae55b5c9ea14cebfab?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳
第4个回答 2011-12-20
VBA是可行的,试试函数的效果
C1输入:=MID(A1,LARGE((CODE(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))<128)*ROW(INDIRECT("A1:A"&LEN(A1))),SUM((CODE(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))<128)*1)),SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))<128)*1)-SUM((CODE(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))<49)*1))
按Ctrl+Shift+Enter确认输入
B1输入:=SUBSTITUTE(A1,C1,"")
------------------------------------
欢迎到Excel Home论坛学习、交流