|
- Sub TEST()
- Dim S1 As String, D, I, M, P, Q, T
- Dim Arr1, Arr2(), S(1 To 3)
- S1 = Range("H2")
- Arr1 = Split(S1, " ")
- Set D = CreateObject("Scripting.Dictionary")
- For I = 0 To UBound(Arr1)
- S(1) = Val(Mid(Arr1(I), 1, 1))
- S(2) = Val(Mid(Arr1(I), 2, 1))
- S(3) = Val(Mid(Arr1(I), 3, 1))
- For P = 1 To 2
- For Q = P + 1 To 3
- If S(P) > S(Q) Then
- T = S(P)
- S(P) = S(Q)
- S(Q) = T
- End If
- Next Q
- Next P
- S2 = S(1) & S(2) & S(3)
- ' Stop
-
- If Not D.Exists(S2) Then
- M = M + 1
- D(S2) = M - 1
- ReDim Preserve Arr2(0 To M - 1)
- Arr2(M - 1) = S2
- End If
- Next I
- S3 = Join(Arr2, " ")
- Range("H3") = S3
- End Sub
复制代码
提取不重复字符并组合(VBA).rar
(11.8 KB, 下载次数: 20)
|
|