谢谢作者: tmtony 时间: 2016-10-31 15:31
Excel小子使用正则的方法实现:
Function sss(rg As Range, rgs As Range)
Dim re, m
Set re = CreateObject("vbscript.regexp")
re.Global = False
re.Pattern = Format(rgs, "yyyy-mm-dd") & "\/(\d+);"
Set m = re.Execute(rg)
sss = m(0).submatches(0)
End Function