Sub test1()
Dim s, s1, tm, reg, hc, tm1, i&, r&
Set reg = CreateObject("vbscript.regexp")
reg.Pattern = "(\S+) ([\dxX]{18}) ([男女]) (\d{1,3}) (.+?)(?=\S+ [\dxX]{18}|\n|$)"
reg.Global = True
s = Sheet3.[a1]
Set s = reg.Execute(s)
For Each s1 In s
MsgBox s1
Next s1
End Sub
Sub test1()
Dim s, s1, tm, reg, hc, tm1, i&, r&
Set reg = CreateObject("vbscript.regexp")
reg.Pattern = "(\S+) ([\dxX]{18}) ([男女]) (\d{1,3}) (.+?)(?=\S+ [\dxX]{18}|\n|$)"
reg.Global = True
s = Sheet3.[a1]
Set s = reg.Execute(s)
For Each s1 In s
MsgBox s1
Next s1
End Sub