Filter non-english characters

Social Media Marketing
#1

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?

#2

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
#3

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