Find cells that DONT contain occurance

[Welsh Mark3]

Is there a formula or feature that allows me to find cells that don't contain a specific value?

For example if column a has email address, what would be the easiest way to find records that don't contain @

 

[Fluff]

You could use conditional with this formula

=ISERROR(FIND("@",A1))

 

[Welsh Mark3]

You could use conditional with this formula

=ISERROR(FIND("@",A1))

Perfect thank you - Good Luck for the 6 Nations

 

[Fluff]

You're welcome & thanks for the feedback.
Good luck to your team as well.