Faster way to filtering arabic/rows with arabic in excel

[learningmarie]

dear mrexcel developers and coders.

good day!

I am filtering an excel file to take out the rows that have Arabic words. I am just a beginner.

could you explain further how I can run this code in excel?

Source Thread: deleting only arabic letters

Or maybe you also have other suggestions?

The excel file I have 3000+ rows both with english and arabic. I just have to retain the english and I just use the filter option which takes a lot of time.

thank you for replying in advance

 

[tonyyy]

Hello learningmarie,
You'll want to copy/paste both the function and sub routines into a regular module. Debra Daiglesh at Contextures has a good blog on How To Add Code To Excel Workbook. Once you've done that, select the range from which you want to remove the Arabic words and run the RemoveArabic routine.
Cheers,
Tony