0

I tried to make a formula which just have to return TRUE | FALSE if a cell contains one or more non-latin characters and tried something like this, but failed - it's always TRUE (found nothing here):

=REGEXMATCH(B2; "[[:^alpha:]]+")

Some examples of data:

  • daocao@yahoo.com - there are no non-latin characters
  • huynhbaoquóqdq@gmail.com - there is a non-latin character

What is wrong with it?

player0
  • 124,011
  • 12
  • 67
  • 124
fallincode
  • 379
  • 4
  • 14
  • Does this answer your question? [(grep) Regex to match non-ASCII characters?](https://stackoverflow.com/questions/2124010/grep-regex-to-match-non-ascii-characters) – MonkeyZeus Jan 13 '20 at 17:12
  • Great! It works, thanks! Is it possible to mark this question as a duplicate or something similar? – fallincode Jan 13 '20 at 17:25
  • Nice. My comment was auto-generated because I casted a close-vote (duplicate) on your post. It takes 3 votes to close it or I believe you can accept the closure early if you are presented with a button which says "Yes, this solved my issue" – MonkeyZeus Jan 13 '20 at 18:28

1 Answers1

1

try:

=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A2, "[^A-Za-z@.]"))="")

0

or TRUE/FALSE reverted:

=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A2, "[^A-Za-z@.]"))<>"")
player0
  • 124,011
  • 12
  • 67
  • 124