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?
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.