try this for e-mail addresses in A1:A10
![]()
Sub DeleteEMail() Dim MyString As String Dim mycell, myrange As Range Set myrange = Sheet1.Range("A1:A10") For Each mycell In myrange MyString = mycell.Value If MyString > "" Then If Not InStr(MyString, "@") > 1 Then mycell.Value = "" End If If InStr(MyString, ".com.") > 1 Then mycell.Value = "" End If If InStr(MyString, "..com") > 1 Then mycell.Value = "" End If If InStr(MyString, " ") > 1 Then mycell.Value = "" End If End If Next End Sub
Bookmarks