CALC FIND = "does not contain"

I have a CALC SS that has E-Mail addresses.
I recently ran into several that do not have a “@” character in the address.

I would like to ‘FIND’ those cells that DO NOT HAVE a ‘@’ character.

I am not seeing a wildcard for that operation … ?
Looked in CALC 6.4.pfd…
Thanks, ⌡im

What about Regular expression (not wildcard!) ^[^@]*$?

Sorry. my posting an answer crossed your comment.

@Lupp No problem! By the way, why + not *?

Reopened - Incorrect closure reason “Duplicate” given + there is no need to close questions. Clicking the check mark next the correct/best answer is the way to indicate (and visualize), that a problem is solved.

Select the range of supposed email addresses and use F&R, Regular expression enabled with Current selection only.
Enter exactly ^[^@]+$ in the field behind “Find:”, the order Find All.
(RegEx can also “search negative”. If you need to understand, study Regular Expression Tutorial - Learn How to Use Regular Expressions, The + in place of the * used by @JohnSUN avoids to find empty cells.)

[Edit 1]
For what you need to do, filtering might be the better means:
Select the column containing the email addresses, go >Data>More Filters>Standard Filter The dialog that opens will offer the variant Does not contain under Condition, and you only need to enter the @ then under Value.
[/Edit 1]

Thank yo to everyone



If the answer works for you, please consider to click the check mark (:heavy_check_mark:) next to the answer. Thanks in advance …

Please do **not** use *Add Answer* if you actually don't answer a question but commenting an answer or responding to another user’s comment. Please use ***add a comment*** for that purpose. Thanks in advance …