Sub aa() Dim rng As Range Dim i As Integer Dim str As String Set d = CreateObject("scripting.dictionary") str = InputBox("请输入关键词", "温馨提示") For Each rng In Range("a1:a" & Range("a65535").End(3).Row) For i = 1 To Len(rng) If rng.Characters(i, 1).Text = str Then d(rng.Value) = "" End If Next i Next rng Range("c1").Resize(d.Count, 1) = Application.Transpose(d.keys) End Sub追问