mid函数的使用方法如下:
工具/原料:电脑Lenovo、Windows10、Excle2010。
1、打开Excle软件,并输入“字符串”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a686c9177f3e67092c19b66a29c79f3df8dc550e?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/cc11728b4710b91238d8056bd1fdfc039245220e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在弹出的窗口中进行操作,类别选择为“文本”,函数选择为“MID”,点击确认。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4610b912c8fcc3ce31d93aa68045d688d43f200e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在弹出的参数窗口中,点击第一个按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9345d688d43f87945ce6bbbbc01b0ef41bd53a0e?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/ac6eddc451da81cb38fe70584066d0160924310e?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/0824ab18972bd4073cdf206869899e510fb3090e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、填写第三个参数,并点击确认。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f510fb30f2442a7c9160e30c343ad4bd113020e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、利用MID函数,完成了从输入的字符串中的第2个字符开始截取了两字符的操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbedb041c5ea6af0f736afc31f0e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)