excel提取前几位数字步骤如下:
电脑:联想thinkpad
系统:Win8.1
软件:excel0.2.0
1、首先打开excel打开数据用LEFT命令,可以取单元格内左边几位字符。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8601a18b87d6277fa26acfa13a381f30e924fc2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、用RIGHT可以取单元格右边几位字符。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/472309f790529822164bc45ac5ca7bcb0a46d42b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、mid可以用来取单元格中间部分字符,如图,取从第5位开始的2个字符。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/64380cd7912397dd3001659d4b82b2b7d0a2872b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、如图需要用FIND函数来查找字符起始点,要注意的是,只查找的是第一个字符开始的地方,如果有两相相同的字符,第2个不会被查到。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/48540923dd54564e5b1d19a0a1de9c82d1584f2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、同时可以用LEN查单元格的字符总数量。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cfde825794eadcd100baa12b2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、用MID根据查找到的字符点就可以取出一段了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb303628a0ecb33c895d1430c2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)