材料/工具:Excel2007
1、例如下图表格数据,现在要把“共”与“,”之间的金额提取到B1单元格到B5单元格中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77094b36acaf2edda677189a831001e93901933a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在这里要运用到MID函数以及LEFT函数在B1单元格输入:=MID(A1,FIND("共",A1)+1,FIND(",",A1)-1-FIND("共",A1))
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df431adcbef760949c3c8ec20dda3cc7dd99efc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、B1单元格输入公式后,按下回车键,得出结果”2860元“
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494eed2e55e6a23f5e0fe98257ef9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、鼠标在B1单元格点下,再放在单元格右下角的绿色小方框上。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/10dfa9ec8a136327db3e93409f8fa0ec09fac7f6?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/3b87e950352ac65cfd1c3600f5f2b21193138aac?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、鼠标在其它单元格点下,完成上面的操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f7246b600c3387443cc47f0f5f0fd9f9d72aa044?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)