Set reg = CreateObject("vbscript.regexp")
With reg
.Global = True
.Pattern = "1\d{10}"
End With
With Sheets(1)
myrow = .Cells(65535, 1).End(xlUp).Row
.Cells(2, 5).Resize(myrow, 2).ClearContents
For i = 2 To myrow
ss = .Cells(i, 1)
Set myval = reg.Execute(ss)
qq = 0
For Each mm In myval
qq = qq + 1
.Cells(i, qq + 4) = mm
Next
Next i
End With