Sub test()
Cells(1, 1) = "1246"
If Not Cells(1, 1).Text Like "*" & "3" & "*" Then MsgBox "不含3"
If InStr(Cells(1, 1), "3") = 0 Then MsgBox "不含3"
End Sub
Sub test()
Cells(1, 1) = "1246"
If Not Cells(1, 1).Text Like "*" & "3" & "*" Then MsgBox "不含3"
If InStr(Cells(1, 1), "3") = 0 Then MsgBox "不含3"
End Sub