代码:结果在A列 Sub 导出() Dim str As String, arr, d As Object Set d = CreateObject("scripting.dictionary") str = [f13].Value arr = Split(str) For i = 0 To UBound(arr) d(arr(i)) = "" Next Columns("A:A").ClearContents Columns("A:A").NumberFormatLocal = "000_ " Range("a1").Resize(d.Count, 1) = Application.Transpose(d.keys) Columns("A:A").Select Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _ :=xlPinYin, DataOption1:=xlSortNormal End Sub 公式:1*(SUBSTITUTE(F13,D13,"")<>F13) |