Function to determine if cell is address

[THEBookMan]

My CALC file has been corrupted and I need to validate thaqt E-Mails are valid.
FIND and REPLACE I have used

isnot(*,"@",*,".",*)
isnot(*"@"*"."*)
isnot(*@*.*)

I am pretty sure I need a MACRO, but I have no idea what it should look like.

Thank you for your help,
⌡im [THE BookMan]

[sokol92]

I think you can check a cell value against a regular expression using a REGEX function.
HTML 5 recommends the following regular expression for E-Mail address validation:

^[a-zA-Z0-9.!#$%&'*+\/=?^_`{|}~-]+@[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?(?:\.[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?)*$

[THEBookMan]

Struggled with that formula ! Couldn’t get it to work.

Can I use <FIND & REPLACE> to locate cells that do NOT have a “@” in it ?

Thanks

[Villeroy]

@sokol92

^[a-zA-Z0-9.!#$%&'*+\/=?^_{|}~-]+@a-zA-Z0-9?(?:.a-zA-Z0-9?)*$`

qa110849.ods (17.0 KB)

[THEBookMan]

Put this in the find and replace dialog ?

[Villeroy]

Why? You asked for a function/formula to determine if a cell is an email address or not.