excel怎么只提取数字?接下来就来为大家介绍一下提取方法,一起来看看吧。
1、需要编辑的
Excel表格。
2、如果是纯数字,在输入结果的单元格里输入=left。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f00f92150cb60f4bfbfaed04f7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、括号里输入要提取的单元格和要提取多少个数字,输入后按
回车键。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ac4bd11373f08202d43febac59fbfbedaa641bf7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、如果是数字与字母的混合,在输入结果的单元格里输入=mid。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/72f082025aafa40fdb6bb44eb964034f79f019f7?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/5bafa40f4bfbfbed39f44cec6af0f736aec31ff7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
excel怎么只提取数字就介绍到这里了,希望对大家有所帮助。
本文章基于Dell灵越5000品牌、Windows10系统、MicrosoftOfficeExcel2019版本撰写的。