首页 > Excel专区 > Excel函数 >

实现从excle单元格是提取数字教程

Excel函数 2023-01-13

方法一:
=LOOKUP(9E+307,–MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&1234567890)),ROW(INDIRECT("1:"&LEN(A1)))))
方法二:
自定义函数:qushu(x)
Function qushu(x)
For b = 1 To Len(x)
a = Mid(x, b, 1)
If a >= 0 And a <= 9 Or a = "." Then
c = c + Mid(x, b, 1)
End If
Next
If c = 0 Then c = ""
qushu = c
End Function


Copyright © 2016-2023 office学习教程网 office.tqzw.net.cn. All Rights Reserved.