C
C
CrewCut2015-10-16 06:29:50
excel
CrewCut, 2015-10-16 06:29:50

How to detect characters in a foreign language in excel?

There is a document with 2k lines (dump of goods from the site). It is necessary to give the customer an extract from this file, where there will be only goods in a language other than Russian (German, Latvian, Lithuanian).
The question is - what function can determine the presence of characters of this language, avoiding false positives if there are only 2-3 characters on them (for example, m2 or cm, mm)?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Fedoryan, 2015-10-16
@AnnTHony

Macro is also possible, without conversion

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question