Sub text()
Dim d, ar, kr, i&, j&
Set d = CreateObject("scripting.dictionary")
[b:c].Clear
ar = Range("a1", Cells(Rows.Count, 1).End(3))
For i = 1 To UBound(ar)
ReDim kr(1 To Len(ar(i, 1)) - 1)
For j = 1 To Len(ar(i, 1)) - 1
kr(j) = Mid$(ar(i, 1), j, 1)
Next
Call ft(kr)
ar(i, 1) = Join(kr, "")
d(ar(i, 1)) = d(ar(i, 1)) + 1
Next
Range("b1:c1") = Array("重复", "次数")
Range("b:b").NumberFormatLocal = "@"
Range("b2").Resize(d.Count, 2) = Application.Transpose(Array(d.keys, d.items))
d.RemoveAll: Set d = Nothing
End Sub因为原数据最后一位是空格,所以不用管第四位(空格)