Hi Leeroy

It would help if you can attach some sample data so that we can have a look at it.

No idea what you meant by non-English words.

(1) Is it foreign language such as Arabic ٱلْأَبْجَدِيَّة ٱلْعَرَ, Mandarin 北方话, Korean우리말etc?

I can only think of using CODE(). It will give 63 in all of the cases.

(2) Or non-English words such as adios, hola etc (spelt using alphabet)?

No idea how to do this in Excel but you can try Googlesheets using the DETECTLANGUAGE() function. (Yes, I know this is an Excel forum )

It will return a language code such as zh, en, es etc. where en=English. It will also work for (1) above.

Hope this helps.

Sunny

Hi sunny,

Thank you for your response,

I have attached an example file , i was to remove rows like 5,6,7,8 from the file.i have a basic knowledge about VBA and failed to find a solution using it.

i am trying for a solution in excel maybe with formulas or VBA.

Regards,

Leeroy.

Hi Leeroy,

there is no file attached.

Regards

Phil

sorry,

please find the attachment below 

Hi Leeroy

I would copy column B to Googlesheets and then use DETECTLANGUAGE() to get the language code.

Then copy the results back to Excel and filter for results not equal to en (English) to delete the rows.

Sunny