方法一:
=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
实现从excle单元格是提取数字教程
本文链接:【实现从excle单元格是提取数字教程】https://www.officeapi.cn/35015.html