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
Sorry. my posting an answer crossed your comment.
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
WOKED GREAT !
⌡im
If the answer works for you, please consider to click the check mark (
) next to the answer. Thanks in advance …