Adding formula for verifyinh E-MAIL address in column B
=IF(B2=(*,"@",*,".",*),"-","◄")
I suspect the “*” is not doing what I think it should be doing.
THANKS, ⌡im
guessing your after:
=IF(B2=IFNA(REGEX(B2;"^([-+\w]+@[-+\w]+\.[a-z]{1,5})$");"@§%&?");"-";"◄")
edit: according to @Wanderer
=IF(B2=IFNA(REGEX(B2;"^([-+\w]+@[-+\w]+\.[a-z]{1,64})$");"@§%&?");"-";"◄")
WOW! Lot more complicated than I anticipated, but works!
Thank you, ⌡im
May I suggest to raise the range. They are not very frequent, but I have seen usage of top-level-domain .berlin and I know .amsterdam is also in use, as TLD. So I’d recommend {1,9} as minimum…
PS via google:
Longest in use 24 chars, max allowed 63 chars.
https://stackoverflow.com/questions/9238640/how-long-can-a-tld-possibly-be/9239264#9239264