Filter non-english characters

Hi guys,

I have a large CVS file that contains contact information and most of it is irrelevant for me. How do I filter all the non-english words or even non-english characters.The column that I want to filter has 2 or 3 words.

I am looking to narrow down the results even more afterwards, but this will be the first step. Is excel my best bet or do you guys know something better?

Just use this

=SUMPRODUCT(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"abcdefghijklmnopqrstuvwxyz_1234567890"))

If you see a number, you have no illegal chars. If you see “VALUE” , you have a char that is not English.

5 Likes

Thank you @MojoJojo

I also wanted to compare 2 lists/columns on Excel. I found out that Microsoft made an add-on that’s quite nice when you need to compare 2 lists that are not exact match. It’s called Fuzzy Lookup.

1 Like