How to mark cells doesn't contain "@"

[yannipr]

Hi
I need a function that look on cell and if the cell doesn't contain "@ " return 0 else return 1
Thank you

[rylo]

Hi

How about

=IF(ISNUMBER(SEARCH("*@*",A3,1)),1,0)

rylo

[snasui]

Try this:

=Isnumber(Search("@ ",A1))+0

Hope this helps.

[VBA Noob]

Or

=1*ISNUMBER(SEARCH("*@*",A1))

VBA Noob

[yannipr]

Great! Thank You