Check for non-latin characters with REGEXMATCH for Google Sheets

Question

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:

[email protected] - there are no non-latin characters
huynhbaoquó[email protected] - there is a non-latin character

What is wrong with it?

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

score 1 · Answer 1 · answered Jan 13 '20 at 18:32

1

try:

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

or TRUE/FALSE reverted:

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

answered Jan 13 '20 at 18:32

player0

124,011
12
67
124

Check for non-latin characters with REGEXMATCH for Google Sheets

1 Answers1

Linked