Private Sub Command1_Click()
Dim X() As String, MYTEXT As String, I As Integer
MYTEXT=" DFDSFSD abc@csdn.net RGFGFGFSC SMITH@YAHOO.COM SSDS"
X = Split(MYTEXT, " ")
For I = 0 To UBound(X)
If InStr(X(I), "@") > 0 And InStr(X(I), ".") > InStr(X(I), "@") Then Debug.Print X(I)
Next
End Sub