|
Sub test()
Dim A, d, i, j, k, t, s1, s2, s3
A = Range("A1").CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 1 To UBound(A)
For j = 1 To Len(A(i, 1))
d(Mid(A(i, 1), j, 1)) = d(Mid(A(i, 1), j, 1)) + 1
Next j
k = d.keys: t = d.items
' A(i, 1) = Join(k, "")
'''''''''''''''''''''''''''''''''''''
s1 = "": s2 = "": s3 = Left(A(i, 1), 1)
For j = 2 To Len(A(i, 1))
s1 = Mid(A(i, 1), j, 1)
s2 = Mid(A(i, 1), j - 1, 1)
If InStr(s3, s1) Then
If d(s2) = 1 Then
s3 = s3 & s1
End If
Else
s3 = s3 & s1
End If
Next j
A(i, 1) = s3
'''''''''''''''''''''''''''''''''''''
d.RemoveAll
Next i
[c1].Resize(i - 1) = A
End Sub
如何按照上述执行 宏后,只能显示出一部分手机号码,想了半天,因为手机号中,也有重复的,版主辛苦了,非常实用非常感谢。
|
|