CODEWITHSUNDEEP
regexif-statementgoogle-sheetsarray-formulasdiacritics
Rodrigo Galindez
Rodrigo Galindez

Reputation: 129

How can I find occurrences of German umlaut characters in Google Sheets?

I have a sheet with names like:

Jürgen
Fabian

The first record has an umlaut character (ä ö ü ß Ä Ö Ü). So I need a way to "flag" this occurrence. A "yes" next to the name (in a new column) would be nice.

Any ideas?

Upvotes: 1

Views: 456

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IF(REGEXMATCH(LOWER(A1:A), "ä|ö|ü|ß"), "yes", ))

0

Upvotes: 1

Related Questions