提取数字请问

heylittleguy

请老师指导，谢谢！

dambcer

正则挺合适的

魚。。

1. =TEXTSPLIT(TEXTJOIN(",",,IF(ISERR(-MID($A1,ROW(1:520)-1,2)),TEXT(LEFT(TEXT(MID(SUBSTITUTE($A1,"月","魚"),ROW(1:520),COLUMN($A:$I)),),COLUMN($A:$I)-1),"[>=];;0;"),"")),",")

复制代码

swl4561255

自定义函数实现的：

1. Function TiQu(myr As String, n As Integer)
   
2. Set reg = CreateObject("vbscript.regexp")
   
3. With reg
   
4.     .Global = True
   
5.     .Pattern = "\d+(\.\d+)?(%)?"
   
6.     .MultiLine = True
   
7. End With
   
8. Set ma = reg.Execute(myr)
   
9. TiQu = ma(n)
   
10. End Function

复制代码

mykitami

=TEXTSPLIT(A1,TEXTSPLIT(A1,VSTACK(SEQUENCE(10)-1,"%","."),,1),,1)

part98

1. =TEXTSPLIT(A1,TEXTSPLIT(A1,VSTACK(ROW(1:10)-1,"%","."),,1),,1)

复制代码

boyuanoffice

=REGEXP(A1,"\d+[\.\d%]*")

cnmlgb9998

公式不复杂 吧。。。。。。。。。。。。。。。。。。。